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

235 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
hetmans1218759(None) 
hetman112510601hetman_
atmans84413962_atmans
desmans1039002desmans
germans1079472germans
hemins113417572he_mins
hitman112710222hitman_
humans112312432h_umans
lemans85316392le_mans
outmans92413282outmans
pitmans11188742pitmans
remans84823002re_mans
atamans9710433atamans
atman75520143_atman_
atmas75721013_atma_s
batman105214063batman_
beans75734693be__ans
bedamns1235733bedamns
bedpans1237173bedpans
bemas96424283be_ma_s
bemeans1148743bemeans
bemoans1138253bemoans
betas75528763bet_a_s
bethank1666273bethank
bethanks1765313bethanks
betons84919553bet_ons
betrays12127823betrays
bettas84913923betta_s
bitmaps1344253bitmaps
caimans113811783caimans
caymans14349513caymans
cetane8315283cet_ane
cetanes9315133cet_anes
chetahs15347073chet_ahs
cotans81317923cot_ans
damans94715983_damans
deans66131393de__ans
dedans85915073de_dans
deewans11306903deewans
demand104314253de_mand
demands114311413de_mands
demeans1039723demeans
demons94917723de_mons
dermas94116813derma_s
desman9311693desman_
detains83716093detains
detrains9411763detrains
dewans105215143de_wans
dextrans1695983dextrans
dolmans10479683dolmans
elans55527753_e_lans
etamins91511833_etamins
etas46432273_et_a_s
ethane94613243_ethane
ethanes103713513_ethanes
etnas54713933_etna_s
etymons1244153_etymons
fetas85624403fet_a_s
fetials103711743fetials
firmans12238523firmans
gentians937563gentians
german9611983german_
germane1049663germane
germens1078633germens
getas65421483get_a_s
haemins122811403haemins
halmas117017893halma_s
hamals114816833h_amals
hammals14409233hammals
hammams13386443hammams
hanumans1344953hanumans
harmins123716723harmins
hatband1346823hatband
hatbands1446293hatbands
hatpins123410643hatpins
hazans183411653h_azans
hazmats2136603hazmats
hazzans18215783hazzans
headman13229633headman_
heads95127113he__ads
heals85733463he__als
heaps105223223he__aps
hears86737373he__ars
heathens143210153heathens
heats85838403he__ats
heavens13439303heavens
heehaws1643363heehaws
hegemons1444893hegemons
hegumens1444303hegumens
helmets12309073helmets
helming133712003helming
helms105619463helm__s
hemal104419803he_ma_l
hematins131714683he_matins
hemes105031083he_m_es
hemin103620933he_min_
hemmers143310843hemmers
hemming15269973hemming
hemps126917333he_m_ps
hems95534943he_m__s
henbane1237363henbane
henbanes1336583henbanes
hennas94211803henna_s
hens75642573he___ns
hepcats1436473hepcats
heptads1335873heptads
heptane1238363heptane
heptanes1339003heptanes
herbals122710613herbals
herdman13238423herdman_
herma105318883herma__
hermae115314473herma_e
hermai118912863herma_i
hermits12312143hermits
herms105626433herm__s
herns84825583he__rns
heroins103518013heroins
herons94820543he_rons
hessians1145053hessians
heteros10312683heteros
heths116317783het__hs
hets75547203het___s
hexads17468203he_xads
hexane16379533he_xane
hexanes17319463he_xanes
hexosans1844123hexosans
heydays1734143heydays
hitmen11239193hitmen_
hogans105914313h_ogans
hogmane1336343hogmane
hogmanes1446783hogmanes
honans94814503h_onans
human102716033h_uman_
humane112812173h_umane
hutment1239173hutment
hutments1345603hutments
hymens1437993h_ymens
hymns1337523h_ym_ns
jeans126022113je__ans
jetlags1533863jetlags
jetons134512613jet_ons
jetsams16124103jetsams
jettons1437273jettons
jetways2094053jetways
leans55536253le__ans
legman949653legman_
leman75622603le_man_
lemmas10349163lemma_s
lemons84415053le_mons
lethals1038113lethals
limans84816303_limans
mans66354553___mans
means75831233me__ans
meatman1137903meatman_
medians103214213medians
merman10513863merman_
messans92710463messans
metals84520893met_als
methane123211793methane
methanes133812163methanes
nemas75321573ne_ma_s
octans81411143oct_ans
ottomans1044493ottomans
outman83115033outman_
overmans13310313overmans
peans75437643pe__ans
pecans101515833pe_cans
pechans14810503pechans
pekans121710553pe_kans
penman10312323penman_
petals84719813pet_als
petnaps1145033petnaps
petsais938433petsais
pitman102412123pitman_
potman102813573potman_
ratans63819373rat_ans
rattans73411953rattans
redans75421023re_dans
reloans7313133reloans
remains94117913re_mains
reman75730153re_man_
remand95618963re_mand
remands104914883re_mands
remaps105012873re_maps
replans92814943replans
retags73414303ret_ags
retains74522253retains
reteams9339563reteams
retears72814923retears
retinas74819353retinas
retrains8314533retrains
returns79712593returns
romans84620243_romans
seaman84015903seaman_
seawans10379943seawans
sedans74816093se_dans
seitans73312303seitans
semens84616973se_mens
sermons9311783sermons
setons64620173set_ons
sewans95215903se_wans
sextans14349273sextans
shamans123610903shamans
shebeans1344703shebeans
sheitans1155603sheitans
shetland1244633shetland
shetlands1343743shetlands
somans84619303_somans
tans46154833__t_ans
teopans939203teopans
tertians839103tertians
tetanus737933tet_anus
tetany959843tet_any
tetrads82910193tetrads
tetras63017623tetra_s
therians1138313therians
thermals13518533thermals
thetas93011573thet_a_s
titans63414913tit_ans
titians72710453titians
titman82711003titman_
tomans85419133_tomans
trans54933043__trans
unmans82211993_unmans
urethans1145243urethans
vegans103910853ve_gans
veterans1148853veterans
weans85326743we__ans
wetland1135353wetland
wetlands1244763wetlands
witans93412933wit_ans
womans114613653_womans
yeans86624883ye__ans
yeoman1138823yeoman_
zetas145018163zet_a_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.406440125.6
2DLD Change Limit1340272357.03319056.9
3Display Results2352350.0902611.1
 (SQL Overall)1786912357.52923733.7
 
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.