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 “hookahs” 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.

141 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
hookahs1744666(None) 
hookah16488241hookah_
hookas135312501hooka_s
hoorahs13399611hoorahs
hooka125513902hooka__
hookers144916522hookers
hookeys17448962hookeys
hookies144017442hookies
hooks125027122hook__s
hookups1633272hookups
hoorah124411112hoorah_
hoorays13418382hoorays
horahs126313872h_orahs
houdahs1434242houdahs
howdahs1733612howdahs
loofahs13364622loofahs
moolahs12347382moolahs
bookers134016613bookers
bookies133819403bookies
bookish163610023bookish
bookoos1337503bookoos
books115729713book__s
booths115313793boo_ths
chooks155312793chook__s
cookers134619463cookers
cookeys16478503cookeys
cookies133719273cookies
cooks115429143cook__s
coolths1236013coolths
coprahs14338153coprahs
dhooras1135943dhoora_s
doodads1035093doodads
dourahs11487253dourahs
gooks105422883gook__s
goombahs1642523goombahs
goorals838713goorals
hahs108333363h___ahs
halakahs18426633halakahs
hallahs133912463hallahs
halvahs16417533halvahs
hamzahs24134373hamzahs
hijrahs2043443hijrahs
hoars85925553h_o_ars
hockers163915913hockers
hockeys19509273hockeys
hocks144925493hock__s
hodads1147963h_odads
hogans105914313h_ogans
hogwash1742713hogwash
hokes126231643h_ok_es
hokums1533923h_okums
holks124720563holk__s
hollas94616903holla_s
honans94814503h_onans
hondas10313353honda_s
honkers143315233honkers
honkeys17439513honkeys
honkies143015143honkies
honks125124523honk__s
hooch135813703hoo_ch_
hooches153812523hooches
hoodies113419833hoodies
hoodoos11109293hoodoos
hoods95124083hoo__ds
hooeys125512323hoo_eys
hoofers134513333hoofers
hoofs115721043hoo__fs
hook116133283hook___
hooked145320553hook_ed
hooker134820173hook_er
hookey164713933hook_ey
hookier143811673hookier
hookiest152712103hookiest
hooking153716693hooking
hookless151238363hookless
hooklet142510813hooklet
hooklets15217203hooklets
hooknose1544273hooknose
hookup1534423hook_up
hooky155220263hook__y
hoopers123616493hoopers
hooplas1239213hooplas
hoopoes121212483hoopoes
hoopoos1298543hoopoos
hoops105621073hoo__ps
hoorahed1545093hoorahed
hooray123011373hoora_y
hootch14386413hootch_
hootches1656973hootches
hooters104520483hooters
hoots84830253hoo__ts
hoovers134312713hoovers
hooves124815493hoo_ves
horah117922053h_orah_
horas86333103h_ora_s
hostas94515833hosta_s
houdah1335173houdah_
howdah1634723howdah_
howks155016853howk__s
hoyas115016163h_oya_s
huppahs1743333huppahs
hurrahs13336773hurrahs
huzzahs2143083huzzahs
khirkahs1741423khirkahs
kooks85217263kook__s
loofah12375813loofah_
loofas9429833loofa_s
lookers114014073lookers
looks95124863look__s
lookups1332953lookups
lotahs9479873_lotahs
mollahs12328283mollahs
moolah11409193moolah_
moolas83615593moola_s
nookies113414963nookies
nooks95420393nook__s
obeahs1135863_obeahs
odahs95610083__odahs
okas85225393__oka_s
okays12609443__okays
okehs12477463__okehs
oohs75220693_oo__hs
oompahs1434263oompahs
oomphs1344723_oomphs
opahs105411983__opahs
polkas1239103polka_s
pooftahs1642363pooftahs
poohs103915713poo__hs
punkahs16284783punkahs
rookies113917103rookies
rooks95325043rook__s
ryokans1443293ryokans
shooks134515633shook__s
sooks94425453sook__s
sooths95715593soo_ths
sukkahs1382703sukkahs
tokays13397773_tokays
tooths96013803too_ths
torahs95115643_torahs
vodkas1443543vodka_s
zooks184716943zook__s

Search took 8 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.420425454.8
2DLD Change Limit1340271416.70319995.1
3Display Results1411410.0463065.2
 (SQL Overall)1786911417.16924925.5
 
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.