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

241 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
atamans971043(None) 
ataman81013061ataman_
atmans84413961at_mans
adamant101110442adamant
adamants1186342adamants
agamas97413452agama_s
atabals938412atabals
ataghans1244262ataghans
atman75520142at_man_
atmas75721012at_ma_s
damans94715982_damans
etamins91511832etamins
patamars1246842patamars
shamans123610902shamans
stamens93411482stamens
tamals84116632_tamals
tampans113310982_tampans
tomans85419132_tomans
yatagans1244082yatagans
abacas104414723abaca_s
abakas123911743abaka_s
abamps1236253abam_ps
abayas114011703abaya_s
abomas101113583aboma_s
acumens1136953acumens
adamance1345543adamance
adamances1445033adamances
adamancy1643713adamancy
adman84517903a_dman_
admass957143a_dmass
afghans1443573afghans
agama85815583agama__
agamids11317013agamids
agamous1037943agamous
agmas85919873a_gma_s
aidman92410623aidman_
airman82414223airman_
ajowans1734003ajowans
alamos8415003alam_os
alanins7315803alanins
alans55636173__alans
almahs118611613a_lmahs
almas76629773a_lma_s
alumins9512983alumins
amahs107819063__amahs
amas67746293__ama_s
amass77119683__amass
amazons1836653amazons
amens75624843__amens
amins75534323__amins
anabas8314083anaba_s
animals94111703animals
animas84418723anima_s
antiman9313883antiman_
anurans73810553anurans
arames84622573aram_es
aramids102810513aramids
aromas81018613aroma_s
artisans888523artisans
asanas6514113asana_s
ashcans1235183ashcans
ashman1148383ashman_
asramas938303asrama_s
asthmas12117363asthma_s
atabal839743ataba_l
ataghan1144653ataghan_
atalaya1044823atalaya
atalayas1144783atalayas
atamasco1242333atamasco
atamascos1351813atamascos
ataps76414833at__aps
ataraxy1743983ataraxy
ataxias14189343ataxias
ataxics16196643ataxics
ataxies142410013ataxies
atlas55821583at_la_s
atma68121773at_ma__
atomics113110853atomics
atomies93918363atomies
atoms76817563atom__s
attains7310983attains
attars64515313at_tars
attorns738443attorns
automan9310883automan_
automats10410443automats
autumns943763autum_ns
avatars1036443avatars
avians93711563a_vians
awakens14416153awakens
axeman1538103axeman_
axman144813183a_xman_
azans146516883__azans
bathmats1545933bathmats
batman105214063bat_man_
batsman1157993batsman_
caimans113811783caimans
calamars1238133calamars
camas96333523_cama_s
camass104114183_camass
caravans1338613caravans
catamarans1453193catamarans
caterans10313223caterans
caymans14349513caymans
chazans21268123chazans
clamant11312433clamant
daman84821163_daman_
damars93814993_damars
damns84916923_dam_ns
databank1542643databank
databanks1642393databanks
desmans1039003desmans
diamins10312213diamins
dolmans10479683dolmans
dramas95814653drama_s
etalons739073etalons
etamin81311853etamin_
etamine91313073etamine
etamines101611813etamines
etymons1244153etymons
examens1637193examens
firmans12238523firmans
flamens124611063flamens
gamas85431363_gama_s
gamays126310913_gamays
gamins94420043_gamins
gateman1057473gateman_
germans1079473germans
gramas94317203grama_s
hamals114816823_hamals
hanumans1344953hanumans
hazans183411653_hazans
hetmans12187593hetmans
humans112312433_humans
jacamars1944003jacamars
japans1539823_japans
jawans1657843_jawans
katakana1142433katakana
katakanas1242133katakanas
lagans75717783_lagans
lamas75532793_lama_s
lauans65113533_lauans
lemans85316393_lemans
limans84816303_limans
llamas888973llama_s
mamas95930773_mama_s
mans66354553___mans
naans55815253_na_ans
ottomans1044493ottomans
outmans92413283outmans
paeans85118263_paeans
pagans95717923_pagans
pajamas18278153pajama_s
panamas113112763panama_s
patacas11311003pataca_s
patamar1147093patama_r
pattamars1342903pattamars
pavans115715593_pavans
pitmans11188743pitmans
platans93413123platans
ptisans9317363ptisans
ptomains1246053ptomains
ratans63819373_ratans
rataplans1143823rataplans
ratatats846063ratatats
rattans73411953rat_tans
remans84823003_remans
romans84620243_romans
sagaman10117563sagaman_
sampans112411003_sampans
sarans64224433_sarans
sataras7315063satara_s
seaman84015903seaman_
seawans10379943seawans
shaman113314283shaman_
shamas113717943shama_s
siamang1045333siamang
siamangs1144063siamangs
somans84619303_somans
stains64923653sta_ins
stalags838643stalags
stamen84115943stamen_
stamina9310793stamina
staminas1048853staminas
stamps105614023stam_ps
statant7313123statant
statins73719773statins
stomas84816323stoma_s
tabuns8489223_tabuns
tains54936323_ta_ins
taipans9269553taipans
takas95520683_taka_s
takins105117403_takins
talars66021683_talars
talas55935893_tala_s
talons64019443_talons
tamal73522623_tama_l
tamale83717403_tamale
tamales93216153_tamales
tamandu1044433_tamandu
tamandus1143943_tamandus
tamari8313403_tamari
tamarins10310843_tamarins
tamaris9413593_tamaris
tambacs13219363_tambacs
tambaks15218153_tambaks
tameins9311413_tameins
tamers84224033_tamers
tames75242013_tam_es
taming94023433_taming
tamis76728733_tam_is
tampan102512323_tampan_
tampons112711563_tampons
tamps95524083_tam_ps
tams67247933_tam__s
tans46154823_t__ans
tapas74627713_tapa_s
taramas9612703tarama_s
tarmacs1138323tarmacs
tarns56433953_ta_rns
tarpans92513533tarpans
tartans72615823tartans
tarzans16329923tarzans
tatamis939723tatam_is
tatars64619793_tatars
tauons63412673_tauons
taxman15328613taxman_
taxons134211503_taxons
titans63414913_titans
tolans64319273_tolans
toman75724053_toman_
trans54933043_t_rans
trapans92812463trapans
tympans14236813_tympans
ulamas8910453ulama_s
unmans82211993_unmans
vitamins1347083vitamins
womans114613653_womans
yamens114010823_yamens
yamuns11336513_yamuns
yatagan1144133yatagan_
yataghans1651903yataghans

Search took 7 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.1401276364.3
2DLD Change Limit1340272416.47020715.1
3Display Results2412410.0803012.5
 (SQL Overall)1786912416.69026710.2
 
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.