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

206 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
hookah1648824(None) 
hooka125513901hooka_
hookahs17446651hookahs
hookas135312491hookas
hoorah124411111hoorah
hooch135813702hoo_ch
hook116133282hook__
hooked145320552hooked
hooker134820172hooker
hookey164713932hookey
hooks125027122hook_s
hookup1534422hookup
hooky155220262hook_y
hoorahs13399602hoorahs
hooray123011372hooray
hootch14386402hootch
horah117922042h_orah
houdah1335172houdah
howdah1634722howdah
loofah12375812loofah
moolah11409192moolah
book106836333book__
booked135319503booked
booker124719193booker
bookie123516003bookie
bookish163610023bookish
bookman15136483bookman
bookoo1248343bookoo
books115729713book_s
booth105522013boo_th
chook146015043chook__
chooks155312793chook_s
cooch124916833coo_ch
cook107236933cook__
cooked135921363cooked
cooker124722453cooker
cookey155414333cookey
cookie123716043cookie
cooks115429143cook_s
cooky145321363cook_y
coolth1139513coolth
coprah133710603coprah
dhoora1035653dhoora_
dhooras1135943dhooras
doodad936423doodad
dourah10479813dourah
gook96429603gook__
gooks105422883gook_s
gooky135818033gook_y
goombah1543113goombah
gooral7310463gooral
hah910655223h___ah
haika125313793haika_
halakah17517953halakah
hallah124115403hallah
halvah15499833halvah
hamzah23135553hamzah
hijrah1934273hijrah
hoar76729163h_o_ar
hoax147718293h_o_ax
hock136031303hock__
hocked165521303hocked
hocker155118563hocker
hockey184813153hockey
hocks144925493hock_s
hodad10311353h_odad
hogan97817703h_ogan
hogwash1742703hogwash
hoke115935933h_ok_e
hoked135326993h_oked
hokes126231643h_okes
hokey155422183h_okey
hokku1135483h_okku
hokum1436763h_okum
holk116027943holk__
holked144913663holked
holks124720563holk_s
holla84918493holla_
hollas94616903hollas
honan85319773h_onan
honda9414983honda_
hondas10313353hondas
honk116931193honk__
honked144517913honked
honker134117463honker
honkey165113823honkey
honkie133011663honkie
honks125124523honk_s
honky156218523honk_y
hood85132333hoo__d
hooded114616743hooded
hoodie105116133hoodie
hoodoo10109983hoodoo
hoods95124083hoo_ds
hoody124919723hoo_dy
hooey114926603hoo_ey
hooeys125512313hooeys
hoof106036583hoo__f
hoofed134614893hoofed
hoofer124014953hoofer
hoofs115721043hoo_fs
hookers144916513hookers
hookeys17448953hookeys
hookier143811673hookier
hookies144017443hookies
hooking153716693hooking
hooklet142510813hooklet
hookups1633263hookups
hoolie93217773hoolie
hooly115022223hoo_ly
hoop96129983hoo__p
hooped125518183hooped
hooper114518313hooper
hoopla1147633hoopla
hooplas1239193hooplas
hoopoe11911233hoopoe
hoopoo1198753hoopoo
hoops105621073hoo_ps
hoorahed1545093hoorahed
hoorays13418373hoorays
hoot75752093hoo__t
hooted104422653hooted
hooter94123923hooter
hoots84830243hoo_ts
hooty115022433hoo_ty
hooved134713123hooved
hoover124314433hoover
hooves124815483hooves
hora76136553h_ora_
horahs126313873h_orahs
horal86328673h_oral
horas86333093h_oras
hosta85917833hosta_
hostas94515823hostas
hotch136214723h_otch
houdahs1434243houdahs
howdahs1733613howdahs
howk145221963howk__
howked177312343howked
howks155016853howk_s
hoya107418373h_oya_
hoyas115016163h_oyas
huppah1644183huppah
hurrah12369183hurrah
huzzah2044423huzzah
khirkah1641423khirkah
kook75822603kook__
kookie9389833kookie
kooks85217263kook_s
kooky114412873kook_y
loofa85912813loofa_
loofahs13364623loofahs
loofas9429833loofas
look87333473look__
looked114717073looked
looker104816953looker
looks95124863look_s
lookup1233453lookup
lotah85315853_lotah
mollah11319453mollah
mooch125313613moo_ch
moola75117033moola_
moolahs12347383moolahs
moolas83615593moolas
nook85728493nook__
nookie103712433nookie
nooks95420393nook_s
nooky124814813nook_y
obeah1038993_obeah
odah87018933__odah
oka76926803__oka_
okas85225393__okas
okay115917663__okay
okeh114615323__okeh
ooh67637093_oo__h
oompah1334253oompah
oomph1236973_oomph
opah96218403__opah
polka11310413polka_
polkas1239103polkas
pooch124815303poo_ch
pooftah1543143pooftah
pooh96027383poo__h
punkah15347093punkah
rook85532033rook__
rooked114918143rooked
rookie103613263rookie
rooks95325043rook_s
rooky126117623rook_y
ryokan1353753ryokan
shook124920153shook__
shooks134515623shook_s
sook84933393sook__
sooks94425453sook_s
sooth85924053soo_th
sukkah12123733sukkah
tokay125513053_tokay
took86531073took__
tooth88020183too_th
torah87125273_torah
vodka1354343vodka_
vodkas1443543vodkas
whoosh15244353whoo_sh
woosh113710733woo_sh
zooks184716943zook_s
zoonal1558083zoonal

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162065.72019705.6
3Display Results2062060.0633269.8
 (SQL Overall)1786912065.92330169.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.