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

225 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
hooklet14251081(None) 
booklet132312641booklet
hooklets15217201hooklets
booklets14247122booklets
boomlet112412272boomlet
brooklet1456402brooklet
hooked145320552hook_ed
hooker134820172hook_er
hookey164713932hook_ey
hookier143811672hookier
hookies144017442hookies
hookiest152712102hookiest
hookless151238362hookless
howlet123518342h_owlet
moonlet92413272moonlet
rootlet73015732rootlet
anklet105618733_anklet
auklet104216833_auklet
bomblet13412263bomblet
boodle93215033boodle_
boodled113410933boodled
boodler103312003boodler
boodles103416043boodles
booked135319503book_ed
booker124719193book_er
bookie123516003bookie_
bookies133819403bookies
bookmen15126263bookmen
bookrest1436493bookrest
boomlets12246673boomlets
bootleg10276633bootleg
bosket124919223bosk_et
brooklets1543683brooklets
cockle143913573cockle_
cockled163710823cockled
cockles153414643cockles
collet84030363_collet
cooked135921363cook_ed
cooker124722453cook_er
cookey155414333cook_ey
cookie123716043cookie_
cookies133719273cookies
cookless14258633cookless
cookout13410153cookout
cooled95224583coo_led
cooler84824713coo_ler
coolest9318643coo_lest
corslet9318063corslet
couplet114717943couplet
docket134721173dock_et
doodle83212853doodle_
doodled10369463doodled
doodler93310153doodler
doodles93614163doodles
doolee73018953doo_lee
doublet103914033doublet
droplet10312113droplet
fooled104317823foo_led
footle93914383footle_
footled113610763footled
footler104011873footler
footles103715713footles
foozle18369203foozle_
foozled20346893foozled
foozler19397593foozler
foozles19329543foozles
froglet11310063froglet
goblet93219483_goblet
goglet84618583_goglet
hackle154916813hackle_
hackled173312483hackled
hackler163512353hackler
hackles162917063hackles
hamlet113722793h_amlet
haole84820083hao_le_
haoles94919803hao_les
harslet10315653harslet
haslet93222713h_aslet
heckle153112093heckle_
heckled17318463heckled
heckler16278573heckler
heckles163711383heckles
hobble133913433hobble_
hobbled153310783hobbled
hobbler143710403hobbler
hobbles143313783hobbles
hocked165521303hock_ed
hocker155118563hock_er
hockey184813153hock_ey
hogget114715763h_ogget
hoke115935933h_ok_e_
hoked135326993h_ok_ed
hokes126231643h_ok_es
hokey155422183h_ok_ey
hokier134214033h_okier
hokiest144114243h_okiest
hole77553393h_o_le_
holed95634133h_o_led
holes84748653h_o_les
holey115626903h_o_ley
holked144913663holk_ed
holler93520613h_oller
holt77852583h_o_l_t
hondle103914523hondle_
hondled123510653hondled
hondles113614523hondles
honked144517913honk_ed
honker134117463honk_er
honkey165113823honk_ey
honkie133011673honkie_
honkies143015143honkies
hooches153812523hooches
hooded114616743hoo_ded
hoodie105116143hoodie_
hoodier113812973hoodier
hoodies113419833hoodies
hoodiest122413173hoodiest
hoodless12289733hoodless
hoodlum1343823hoodlum
hooey114926603hoo__ey
hoofbeat1644093hoofbeat
hoofed134614893hoo_fed
hoofer124014953hoo_fer
hoofless14258013hoofless
hook116133283hook___
hooka125513903hook__a
hookah16488243hook_ah
hookahs17446653hookahs
hookas135312493hook_as
hookers144916513hookers
hookeys17448953hookeys
hooking153716693hooking
hooklike1435123hooklike
hooks125027123hook__s
hookup1534423hook_up
hookups1633263hookups
hooky155220263hook__y
hoolie93217783hoo_lie
hooly115022223hoo_l_y
hooped125518183hoo_ped
hooper114518313hoo_per
hoopla1147633hoopl_a
hooplas1239193hooplas
hoopless13279253hoopless
hoopoe11911233hoopoe_
hoopoes121212483hoopoes
hoot75752103hoo___t
hooted104422663hoo_ted
hooter94123933hoo_ter
hootier104915353hootier
hootiest113115643hootiest
hooved134713123hoo_ved
hoover124314433hoo_ver
hooves124815483hoo_ves
hopple132910483hopple_
hoppled15338083hoppled
hopples142810713hopples
hornet94926433h_ornet
hostler103411023hostler
hoveled14209293hoveled
howked177312343howk_ed
howled134014963h_owled
howler123514313h_owler
howlets13329223h_owlets
hoyle11314413h_oyle_
hoyles12315013h_oyles
huckle153913073huckle_
huckles163612623huckles
kookie9389843kookie_
kookier10398283kookier
kookiest11268133kookiest
locket123922473lock_et
lockset13311163lockset
looked114717073look_ed
looker104816953look_er
lookist1139563lookist
lookout1148033lookout
mooley11311633moo_ley
moonlets10247473moonlets
moonlit9229333moonlit
moonset92413043moonset
noodle73212543noodle_
noodled9339923noodled
noodles83513193noodles
nookie103712433nookie_
nookies113414963nookies
omelet8317073_omelet
oodles73517183_oodles
outlet63728683_outlet
owlet83324463__owlet
piolet83225643pio_let
pocket144622623pock_et
poodle93112043poodle_
poodles103013513poodles
pooled94619813poo_led
pooler83819843poo_ler
rocket125425283rock_et
rooked114918143rook_ed
rookie103613263rookie_
rookier114012383rookier
rookies113917103rookies
rookiest122912173rookiest
rootle63214453rootle_
rootled83410533rootled
rootles73215633rootles
rootlets8308653rootlets
shooled115212663shoo_led
socket123923523sock_et
toilet66228093_toilet
tonlet62924703_tonlet
tooled74918903too_led
tooler63818613too_ler
tootle62613813tootle_
tootled83511043tootled
tootler73511123tootler
tootles72915603tootles
townlet1049733townlet
violet92620923vio_let
woodlot1147023woodlot
wooled103715503woo_led
woolen93111373woo_len
wooler93615873woo_ler
woolled1136643woolled
woollen1034723woollen
zooglea1733373zooglea

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.1531167915.0
2DLD Change Limit1340272257.44018014.4
3Display Results2252250.0932419.4
 (SQL Overall)1786912257.68623248.9
 
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.