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 “howdahs” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
howdahs173361(None) 
houdahs1434241houdahs
howdah1634721howdah_
hodads1147962ho_dads
hondas10313352honda_s
hookahs17446652hookahs
hoorahs13399602hoorahs
horahs126313872ho_rahs
houdah1335172houdah_
howdies142911952howdies
odahs95610082_o_dahs
aoudads973763aoudads
chowders17387543chowders
chuddahs18222583chuddahs
codas84724243co_da_s
coprahs14338153coprahs
cowpats1437713cowpats
dahs88231813___dahs
doodads1035093doodads
dourahs11487253dourahs
dowdies123412733dowdies
goddams1233983goddams
gowans105512293gow_ans
gowds105814043gowd__s
hahs108333363h___ahs
hallahs133912463hallahs
halvahs16417533halvahs
hamzahs24134373hamzahs
hardass1139753hardass
heydays1734143heydays
hijrahs2043443hijrahs
hoars85925553ho__ars
hodad10311353ho_da_d
hoddens12378803hoddens
hoddins12289373hoddins
hods87239863ho_d__s
hogans105914313ho_gans
hogwash1742713hogwash
hoidens11329083hoidens
holdall1145473holdall
holdalls1244333holdalls
holders113715903holders
holds94623243hold__s
holdups1333593holdups
holidays1544103holidays
hollas94616903holla_s
holydays1843473holydays
honans94814503ho_nans
honda9414983honda__
hondles113614523hondles
hoodies113419833hoodies
hoodoos11109293hoodoos
hoods95124083hood__s
hookah16488243hookah_
hookas135312493hooka_s
hoorah124411113hoorah_
hoorays13418373hoorays
horah117922053ho_rah_
horas86333103ho_ra_s
hordes104921633hord_es
hostas94515823hosta_s
hotdogs1234453hotdogs
howdie13349733howd_ie
howdied15296843howdied
howdy155711413howd__y
howes114730263how__es
howffs18535043how_ffs
howfs144814503how__fs
howks155016853how__ks
howlers133312353howlers
howlets13329223howlets
howls116219223how__ls
hows106345603how___s
hoyas115016163ho_ya_s
hoydens14347403hoydens
huppahs1743333huppahs
hurrahs13336773hurrahs
huzzahs2143083huzzahs
jordans1566833jordans
jowars16369653jow_ars
keddahs1642923keddahs
khedahs1852953khedahs
loofahs13364623loofahs
lotahs9479873lo_tahs
modals93914453mo_dals
mollahs12328283mollahs
moolahs12347383moolahs
nowadays1542263nowadays
noways12127733now_ays
obeahs1135863_obeahs
odah87018933_o_dah_
odas57230263_o_da_s
oompahs1434263oompahs
opahs105411983_o_pahs
pardahs13289673pardahs
powders134111553powders
purdahs13285483purdahs
rowans95715343row_ans
rowdies113112693rowdies
rowths12458173row_ths
sodas64123543so_da_s
soldans83210403soldans
soudans8309353soudans
sowans94215893sow_ans
sowars94318013sow_ars
sowcars1236013sowcars
todays10458103to_days
torahs95115643to_rahs
towpaths1643113towpaths
whidahs1743333whidahs
whydahs2041883whydahs
yodhs12669013yo_d_hs

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271125.79623124.1
3Display Results1121120.0303733.3
 (SQL Overall)1786911126.23228673.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.