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

385 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
helmets1230907(None) 
helmet113718931helmet_
pelmets11309691pelmets
cermets1139712cermets
emmets10349152_emmets
hamlets123211402hamlets
hellers103619832hellers
helmed124513692helme_d
helmeted1435832helmeted
helmless1334272helmless
helms105619462helm__s
helots95217702hel_ots
helpers123311852helpers
helpmeets1641922helpmeets
helves124316062helve_s
hemes105031082he_me_s
hemmers143310842hemmers
hermits12312142hermits
pellets94014782pellets
pelmet103419242pelmet_
relets64025672rel_ets
telnets738372telnets
velvets13326692velvets
aglets73915683agl_ets
ailments1039433ailments
almehs11619493_almehs
almes75126543_alme_s
armets84918353_armets
armlets94610063armlets
ballets93719513ballets
beckets15399823beckets
beets76131443be__ets
befrets1237613befrets
begets96215523be_gets
beliefs12448583beliefs
beliers94617383beliers
belies84631053belie_s
belles85325993belle_s
belters93819413belters
belts75931163bel__ts
bennets94712163bennets
berets85822523be_rets
bermes106023003berme_s
besets85718803be_sets
besmuts1134683besmuts
billets94516153billets
blets75324943_bl_ets
bluets87215493_bluets
bullets93516393bullets
callets93821703callets
calmest11312343calmest
calumets1236283calumets
camlets114314623camlets
celebs1037883cel_ebs
celts75325783cel__ts
cements112714223ce_ments
cermet10321153cermet_
chalets122813473chal_ets
chelates132713843chelates
chevrets16255323chevrets
collets93517903collets
comets105823583_comets
culets85518513cul_ets
cullets94015613cullets
deets65330243de__ets
delates83526283delates
deles65139253del_e_s
delete73620703del_ete
deletes83117933del_etes
delfts10439673del_fts
delicts104012253delicts
delimes10314193delime_s
delimits1137573delimits
delists84414173delists
delts65731793del__ts
delvers113411993delvers
delves104917083delve_s
dements103016623de_ments
demes86032693de_me_s
demits94918073de_mits
dolmens10388693dolmens
dulcets1046283dulcets
ebbets10376833_ebbets
eeliest73516473eeliest
egrets72712243_egrets
elates65032363_elates
elders74817303_elders
eldest72912683_eldest
elects83315003_elects
elements10312173_elements
elemis8312383_elemis
elints65816423_elints
elites66027123_elites
elmiest9310743_elmiest
elms67322703_elm__s
eluents738703_eluents
elutes64020313_elutes
elvers93814983_elvers
elves85118743_elve_s
emes65434663_e_me_s
emeus76913333_e_meus
emits75421473_e_mits
emmers104013223_emmers
emmet94221383_emmet_
eyelets1057523eyel_ets
fellers104117543fellers
fellest10313753fellest
felts85324543fel__ts
femes105626223fe_me_s
femmes135410213femme_s
ferments13311473ferments
ferrets103111393ferrets
filets94718953fil_ets
fillets103414753fillets
filmers124211293filmers
filmsets1353413filmsets
fleets96915063_fleets
fumets114311813_fumets
gallets83517403gallets
gelants82611443gelants
gelates83219583gelates
gelders93812573gelders
gelees74116263gel_ees
gelts65924613gel__ts
gemots93712153ge_mots
genets75716663ge_nets
germens1078633germens
gimlets10338433gimlets
gleets75315053_gleets
gullets84013713gullets
haets86525123h__aets
haffets1636053haffets
halberts1335973halberts
halers94926913hal_ers
hales85449843hal_e_s
halest94823273hal_est
halites103221193halites
hallels103310133hallels
halmas117017893halm_as
halms105225213halm__s
haloes94623863haloe_s
halters104619803halters
halts85230103hal__ts
halvers133311423halvers
halves124717093halve_s
hames106138703h_ame_s
hamlet113722793hamlet_
hammers144216063hammers
harmers124116593harmers
haslets102510863haslets
hazmats2136603hazmats
headers113819393headers
headsets1236053headsets
healers104319463healers
heapers123616673heapers
hearers104319783hearers
hearts96218943he_arts
heaters104225223heaters
heats85838403he__ats
heaumes1237423heaume_s
heavens13439303heavens
heavers133717193heavers
heaves124120303heave_s
hebes105521673he_be_s
heders104119763he_ders
hedgers124310263hedgers
hedges115016263hedge_s
heeders114213743heeders
heeds95420423he__eds
heelers103815623heelers
heelless11257653heelless
heels85625533he__els
heezes184211643heeze_s
hefters134312003hefters
hefts116218153he__fts
hegumens1444303hegumens
heifers1337933heifers
heights14399443heights
heiress1036813heiress
heists96814633he_ists
heliast10312073heliast
heliasts1136103heliasts
helices12313723helices
helios94816633hel_ios
heliums12188303heliums
helixes1739133helixes
hellcats1346323hellcats
helled104024703helle_d
heller93322513helle_r
helleri10389973helleri
helleris113010183helleris
hellery13329213hellery
helloes103717463helloes
hellos95321683hel_los
hells85032043hel__ls
helm95530023helm___
helmeting1545503helmeting
helming133712003helming
helminth1644943helminth
helminths1742773helminths
helos84928063hel__os
helot85332683hel_ot_
helped124714153helpe_d
helper114313093helpe_r
helpless1335063helpless
helpmate1545603helpmate
helpmates1645513helpmates
helpmeet1544253helpmeet
helps105219343hel__ps
helve115018093helve__
helved134313703helve_d
heme95034413he_me__
hemins113417573he_mins
hemmed144211463hemme_d
hemmer134112643hemme_r
hemps126917333he_m_ps
hems95534943he_m__s
henbits12177003henbits
henges104516463henge_s
henleys1334843henleys
hents87330743he__nts
hepcats1436473hepcats
heppest14228143heppest
herders113914123herders
heres86245903he_re_s
hereto9313693he_reto
heriots10312063heriots
hermetic15310243hermetic
hermetism1646643hermetism
hermetist1448953hermetist
hermit11519443hermit_
herms105626433herm__s
heroes94923823heroe_s
herpes115517323herpe_s
hests85829933he__sts
hetmans12187593hetmans
hets75547203h___ets
hewers123715273he_wers
hexers165612753he_xers
hexes155123043he_xe_s
heydeys1732863heydeys
hillers103718733hillers
hilts86924413hil__ts
hoggets12498323hoggets
holders113715903holders
holes84748653hol_e_s
holies94630033holie_s
holiest104319623holiest
holists104413963holists
hollers103818233hollers
holms105117803holm__s
holts85627913hol__ts
homers114821973h_omers
homes106938813h_ome_s
homeys145012873h_omeys
hornets104113553hornets
howlets13329223howlets
hueless1058823huel_ess
hullers103616263hullers
hummers143813063hummers
hutments1345603hutments
hymens1437993h_ymens
inlets63915573inl_ets
islets64513083isl_ets
jennets14517633jennets
keets95123483ke__ets
keleps12478813kel_eps
kelters113813753kelters
kelts95222633kel__ts
kermes124616133kerme_s
kermess13396223kermess
keysets1434343keysets
kismets13306883kismets
leets54927123__leets
lets47147943__l_ets
mallets93318493mallets
mammets103911113mammets
maumets11369693maumets
meets74224613me__ets
melders103213913melders
melees83618083mel_ees
melters93918313melters
melts74930103mel__ts
memes94927703me_me_s
millets94216843millets
mullets93614783mullets
neumes83112623neume_s
omelets938333omel_ets
owlets93110393owl_ets
palets85122313pal_ets
pallets93919303pallets
palmers113513623palmers
peles75738083pel_e_s
pelites93821993pelites
pellet83326553pellet_
pelters93720313pelters
pelts76128813pel__ts
pelves114514663pelve_s
permits11314003permits
phellems1544543phellems
pullets94015163pullets
ramets83517393_ramets
reamers94221083reamers
reemits9611303reemits
reflets103513153reflets
reglets83512983reglets
regrets83212923regrets
relates73731433relates
relents74018503relents
relet54749823rel_et_
relicts94414593relicts
reliefs10439433reliefs
reliers75519213reliers
relies65036423relie_s
relists73817053relists
relucts9369673relucts
relumes9612513relume_s
remeets93712413remeets
remelts93511493re_melts
remet74843723re_met_
remits85622943re_mits
rennets75212633rennets
resets65427613re_sets
resmelts1046143resmelts
revets94022173re_vets
rewets94617213re_wets
rhemes115913183rhe_me_s
rillets74216153rillets
sallets73719653sallets
samlets93813553samlets
seamers94719433seamers
secrets9311773secrets
seemers93814333seemers
segments1138903segments
selects91912143selects
sellers73721313sellers
selles64426983selle_s
selves94119613selve_s
semens84616973se_mens
semes75731583se_me_s
sennets73712583sennets
septets998953septets
sestets7911473sestets
sextets1497143sextets
sheets93918503she__ets
shellers112812573shellers
shelters113412813shelters
shelvers14388813shelvers
shelves134112093shelve_s
sherbets1335213sherbets
sleets64318873_sleets
teemers95012903teemers
teles54536003tel_e_s
telfers10299073telfers
tellers73717593tellers
telnet6518833telnet_
telomes9310533telome_s
tempts10439453te_mpts
tenets65518953te_nets
tercets93512443tercets
termers95414503termers
terrets72913583terrets
themes115319253the_me_s
thermels13607763thermels
thermes126214613therme_s
thermits1338513thermits
valets93715623val_ets
veldts10417753vel_dts
velites103417303velites
velvet123613753velvet_
velvety16304003velvety
vermes115019143verme_s
versets103913103versets
vervets13419753vervets
wallets103914833wallets
weets85427723we__ets
welders113313413welders
weldments1544423weldments
welters103516063welters
welts85225193wel__ts
whelmed16375153whelme_d
whelms14377573whelm__s
willets104414323willets
yellers103912953yellers
yelpers12348203yelpers

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 Limit1340273856.70619986.1
3Display Results3853850.1233130.1
 (SQL Overall)1786913857.24924650.4
 
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.