Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “hoards” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
hoards10491262(None) 
boards94616931boards
hards96435651h_ards
hoard94918311hoard_
hoars85925551hoar_s
holards1148431holards
awards107113452awards
bards87139642_bards
beards94116672beards
board85523002board_
boars75229602boar_s
boarts84716872boarts
boyards13399322boyards
cards85137932_cards
chards125119732chards
chords125214632cho_rds
cords86030622co_rds
cowards1339612cowards
dotards937252dotards
fards96629842_fards
fords95328182fo_rds
goads77022852goa_ds
gourds8108252gourds
guards84611572guards
haars85620472haar_s
hands95327382h_ands
hard85443502h_ard_
hardy125622062h_ardy
hares86255542h_ares
harks126333432h_arks
harls85634502h_arls
harms106829022h_arms
harps105926872h_arps
harts88441592h_arts
hazards2037462hazards
heads95127112hea_ds
heard95222752heard_
hears86737372hear_s
hearts96218942hearts
herds96424682h_erds
hoar76729162hoar__
hoarded12368342hoarded
hoarder11329232hoarder
hoarders12307432hoarders
hoarse94411322hoarse
hoary114516762hoar_y
hoaxes163611692hoaxes
hodads1147962hodads
hods87239872ho__ds
hoers85724922hoer_s
holard10410572holard_
holds94623242ho_lds
hoods95124082ho_ods
horahs126313872horahs
horas86333102ho_ras
horde94623052ho_rde
hordes104921632ho_rdes
horns86125332ho_rns
hotrods1148282hotrods
hounds104413132hounds
houris94514582houris
hours85422392hour_s
hurds95219072h_urds
lards65331862_lards
liards75212612liards
loads65323372loa_ds
lords64923502lo_rds
nards65928462_nards
oars46846032_oar_s
pards85634332_pards
roads66523622roa_ds
roars55622242roar_s
sards64736182_sards
shards104319172shards
soars54732512soar_s
sords64527802so_rds
swards105415132swards
toads65621072toa_ds
towards1138782towards
uphoards1443762uphoards
wards97734402_wards
woads94818442woa_ds
woalds10427582woalds
words95425072wo_rds
yards95324612_yards

Search took 6 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691825510.846211218.7
2DLD Change Limit82551854.43618609.3
3Display Results85850.0136538.5
 (SQL Overall)178691855.29533747.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.