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

345 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
henleys133484(None) 
henley1237481henley_
healers104319462healers
heelers103815622heelers
hellers103619832hellers
henges104516462henge_s
henrys12366102hen_rys
heydeys1732862heydeys
honeys124016082hon_eys
honkeys17439512honkeys
hunkeys17386192hunkeys
hurleys13407332hurleys
medleys13115332medleys
aeneus61111143aen_eus
alleys95113303_alleys
aneles64626293anele_s
awnless1035923awnless
baileys12388933baileys
barleys125011843barleys
bedless1039703bedless
befleas1236973befleas
belays114313853be_lays
belles85325993belle_s
bendays13327513bendays
bendees103913863bendees
benders104021063benders
bendys12518383ben_dys
benes75536233ben_e_s
bennes86019013benne_s
bennets94712163bennets
burleys12479673burleys
ceilers93912533ceilers
celebs1037883ce_lebs
censers94313903censers
censes83721803cense_s
centers94420603centers
chanteys16387493chanteys
charleys1695633charleys
chimleys1883633chimleys
chinless1337493chinless
coneys115218423con_eys
conveys15308223conveys
dealers84118613dealers
defleas1147223defleas
delays104014053de_lays
deles65139253de_le_s
denes65639723den_e_s
deniers84515183deniers
denies74729643denie_s
deploys1336523deploys
dewless1137473dewless
dingeys12458403dingeys
dinkeys15507263dinkeys
donkeys15426663donkeys
doyleys14384923doyleys
enders74324053_enders
endless839833_endless
enjoys1644603_enjoys
enters64425643_enters
envoys1255143_envoys
feelers103814743feelers
feeless103511103feeless
fellers104117543fellers
fencers123810623fencers
fences114617113fence_s
fenders113717263fenders
fennecs12305693fennecs
fennels10387903fennels
fernless1136063fernless
finless102810783finless
fleys117015603__fleys
foleys123810463_foleys
galleys11369713galleys
gelees74116263ge_lees
genders93616783genders
genes65133093gen_e_s
genets75716663gen_ets
genies75324943genie_s
genres75515623genre_s
gentes75324163gente_s
gentles83714343gentle_s
gleys96514853__gleys
gulleys11438523gulleys
gunless8299633gunless
hailers104017263hailers
halers94926913h_alers
hales85449843h_ale_s
hallels103310133hallels
hamlets123211403hamlets
hances115621283hance_s
handers114224333handers
handlers124014143handlers
handles114020653handle_s
handless123512063handless
hangers113120813hangers
hankers144218133hankers
hansels104011663hansels
hanses95022633hanse_s
hantles104117513hantle_s
haoles94919803haole_s
hapless123311333hapless
haslets102510863haslets
hatless103813443hatless
haulers104012443haulers
hawkeys20414703hawkeys
headers113819393headers
headless12289863headless
healed105121443heale_d
healer94221803heale_r
heals85733463heal__s
healths13478753healths
heapers123616673heapers
hearers104319783hearers
heaters104225223heaters
heatless113011463heatless
heavens13439303heavens
heavers133717193heavers
heaves124120303heave_s
hebes105521673he_be_s
hecklers17357123hecklers
heckles163711383heckle_s
heddles123311623heddle_s
heders104119763he_ders
hedgers124310263hedgers
hedges115016263hedge_s
heeders114213743heeders
heedless12278813heedless
heeds95420423he__eds
heeled104018413heele_d
heeler93917313heele_r
heelless11257653heelless
heels85625533he__els
heezes184211643heeze_s
hefters134312003hefters
heifers1337933heifers
heiled104415613heile_d
heils85222193heil__s
heinies102514543heinie_s
heiress1036813heiress
heirless1146053heirless
helios94816633he_lios
helled104024703helle_d
heller93322513helle_r
helleri10389973helleri
helleris113010183helleris
hellery13329213hellery
helloes103717463helloes
hellos95321683he_llos
hells85032043he_l_ls
helmets12309073helmets
helmless1334273helmless
helms105619463he_l_ms
helos84928063he_l_os
helots95217703he_lots
helpers123311853helpers
helpless1335063helpless
helps105219343he_l_ps
helves124316063he_lves
hemes105031083he_me_s
hemmers143310843hemmers
henbits12177003henbits
hence104920043hence__
henge94819833henge__
henlike1448693henlike
hennas94211803hen_nas
hennery1335303hennery
henpeck1843083henpeck
henpecks1942873henpecks
henries102718283henries
henry114014473hen_ry_
hens75642573hen___s
hented104218753hente_d
hents87330743hen__ts
herbless1336663herbless
herders113914123herders
heres86245903he_re_s
heresy125011233he_resy
herls85226433herl__s
heroes94923823heroe_s
herpes115517323herpe_s
hewers123715273he_wers
hexers165612753he_xers
hexes155123043he_xe_s
heydays1734143heydays
heydey1634633heydey_
hickeys19508223hickeys
hillers103718733hillers
hinders113718503hinders
hingers113420213hingers
hinges105121033hinge_s
hinters103719583hinters
hipless12399923hipless
hitless103211193hitless
hockeys19509273hockeys
holes84748653h_ole_s
holey115626903h_oley_
hollers103818233hollers
homeys145012883h_omeys
hondles113614523hondle_s
honers94324973hon_ers
hones88144493hon_e_s
honey115629913hon_ey_
honkers143315233honkers
honkey165113823honkey_
hooeys125512323h_ooeys
hookeys17448963hookeys
hornless1137363hornless
hoseys124614013h_oseys
howlers133312353howlers
howlets13329223howlets
hoyles12315013hoyle_s
hueless1058823hueless
hullers103616263hullers
hungers114013303hungers
hunkers143314333hunkers
hunkey164210883hunkey_
hunters103915733hunters
hurlers103714323hurlers
hurley125012523hurley_
hymnless1632803hymnless
inlays9389873_inlays
inlets63915573_inlets
innless7288293innless
jennets14517633jennets
jerseys1733243jerseys
keglers12277773keglers
keleps12478813ke_leps
kennels11387193kennels
kentes105118653kente_s
kerseys1433993kerseys
keyless1436163keyless
kinless113310273kinless
langleys1245103langleys
legless838013legless
lenders84419643lenders
lenes54738523len_e_s
lenses64620893lense_s
lensless835583lensless
leys76430183___leys
linseys1035083linseys
manless93012933manless
medley1298343medley_
melees83618083me_lees
menders103818803menders
menses84222453mense_s
mentees93214503mentees
merles85322763merle_s
mewlers12288983mewlers
moneys115513623mon_eys
monkeys16407423monkeys
mooleys1236863mooleys
motleys1235683motleys
muleys11409643_muleys
mulleys12299203mulleys
nenes55329673nen_e_s
netless739863netless
onlays9398713_onlays
parleys125212373parleys
peaveys15324063peaveys
pedlers103013273pedlers
peelers93615593peelers
pegless1038053pegless
peles75738083pe_le_s
pellets94014783pellets
pencels113610053pencels
penes75839223pen_e_s
penners93414183penners
pensees9311203pensees
phellems1544543phellems
phoneys15437143phon_eys
pinkeys16378213pinkeys
pulleys12399143pulleys
punkeys16366493punkeys
pusleys12286233pusleys
reales64934123reale_s
redlegs936823redlegs
reelers73520273reelers
reflets103513153reflets
reglets83512983reglets
reinless8139433reinless
rekeys13347693re_keys
relays94316753re_lays
relets64025673re_lets
renders83821673renders
renews93811753ren_ews
rennets75212633rennets
renters74224813renters
rentes65431193rente_s
replays12399763replays
ridleys11145783ridleys
runless72810423runless
runlets73310773runlets
sealers74323553sealers
sellers73721323sellers
selles64426983selle_s
senders83022353senders
seniles72618023senile_s
sennets73712583sennets
senseis73310643senseis
senses63923943sense_s
sexless1467243sexless
shanteys14395513shanteys
sheeneys14294903sheeneys
shellers112812583shellers
shinneys14275093shinneys
sinless73014213sinless
smileys12336323smileys
sonless72612613sonless
sunless73013693sunless
teles54536003te_le_s
tellers73717603tellers
tellys9348843te_llys
telnets738373telnets
tenders83719723tenders
tenets65518953ten_ets
tenners74014923tenners
tenrecs936033tenrecs
tenses64722553tense_s
tenters73921103tenters
tentless8229843tentless
tenues63816443tenue_s
thewless1433923thewless
tonlets73212503tonlets
unlays93810493_unlays
unless62413073_unless
valleys13407483valleys
vealers103214293vealers
veilers103911823veilers
veinless11136263veinless
veinlets11144833veinlets
vendees114011453vendees
venders113717003venders
veneers103710293veneers
venges104015153venge_s
venters103717733venters
ventless11249053ventless
venues95115203venue_s
venules104011483venule_s
volleys13316643volleys
webless1237003webless
wheelers14287733wheelers
winceys15395523winceys
winless103212283winless
yellers103912953yellers
yentes95517603yente_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.390458182.1
2DLD Change Limit1340273456.89019452.4
3Display Results3453450.1262738.1
 (SQL Overall)1786913457.40624127.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.