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

172 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
amidols1045756(None) 
amidol9489571amidol_
aldols7109712a_ldols
amadous1038502amadous
amatols938182amatols
amides95722662amid_es
amidins103713102amidins
amido85720982amido__
amidone10349312amidone
amidones11348662amidones
amids85627512amid__s
amigos94511212amigo_s
idols65514132__idols
abiders104011083abiders
abides94719893abid_es
acidly125211793acid_ly
acidoses1136773acidoses
acidosis1146143acidosis
acids87121003acid__s
acinous9310933acinous
adios65822863adi_o_s
adipous1037183adipous
admirals1144353admirals
ados57633513a__do_s
agios65919863agi_o_s
aiders74524633a_iders
aides65336603a_id_es
aids57846363a_id__s
aikidos1253883aikido_s
ails45654713a_i__ls
aioli5318313a_i_oli
aiolis6316843a_i_olis
aldol61212333a_ldol_
alidads936293alidads
aliyos9349533aliyo_s
aludels835303aludels
amadou977613amado_u
amatol838693amatol_
amazons1836653amazons
ambos95321253am_bo_s
amiable11312033amiable
amiably1438303amiably
amias75831473ami__as
amices105018013ami_ces
amicus103810003ami_cus
amid77036353amid___
amidase1036733amidase
amidases1136653amidases
amide86128483amid__e
amidic114012873amid_ic
amidin94015673amid_in
amidine103613853amidine
amidines113010853amidines
amidogen1243913amidogen
amidogens1343653amidogens
amidst94913233amid_st
amies76837693ami__es
amigas95912173ami_gas
amigo86515473amigo__
amines84727983ami_nes
amino75425503amino__
amins75534323ami__ns
amirs75924923ami__rs
amis66445323ami___s
amiss75823073ami__ss
amities9317383amities
amitoses1039053amitoses
amitosis1047203amitosis
amitrole1045173amitrole
amitroles1144723amitroles
ammos94815823am_mo_s
amnions93710913amnions
amnios84912523amnio_s
amoks11413553am__oks
amole75724593am__ole
amoles84122193am__oles
amorous9311133amorous
ampuls1098893am_puls
amyls104512693am__yls
anils56326723ani__ls
animals94111703animals
anions64123033ani_ons
anisole71010833anisole
anisoles81010123anisoles
apicals1159923apicals
apodous1037403apodous
ardors74416873a_rdors
argols74514613a_rgols
aridly105513703arid_ly
ariels65119373ari_els
arils58732203ari__ls
asides75118873asid_es
audios72312283audio_s
avidins11349003avidins
avidly13548783avid_ly
avions94114393avi_ons
avisos95410483aviso_s
awols84713523a__wols
axils127217503axi__ls
axioms15408053axi_oms
axions134713483axi_ons
azides165113803azid_es
azido155411543azido__
bridals1038623bridals
camions113916133cami_ons
camisole1246173camisole
camisoles1345583camisoles
camphols1746243camphols
capitols12247333capitols
cibols1039523_cibols
didoes85716963_didoes
didos76820813_dido_s
diols65521013_di_ols
dols56943053___dols
eidola737683_eidola
eidos65817753_eido_s
fidos95819053_fido_s
frivols1334743frivols
gambols1238593gam_bols
guidons936623guidons
halidoms1485823halidoms
humidors1443993humidors
idol56818633__idol_
idyls9498803__idyls
imides94515343imid_es
imido85812243imido__
imids86015143imid__s
indols74714203_indols
laminals10339313laminals
laminous1037953laminous
lidos65219883_lido_s
maidens10349663maidens
maids86327143maid__s
maills84215283mai_lls
mails76037783mai__ls
maltols939403maltols
mandola1039023mandola
mandolas1139133mandolas
medals94218063_medals
metols84115773_metols
miaous8511693_miaous
miaows1145473_miaows
miauls8178713_miauls
middle103414983_middle
middles113415303_middles
midges103516483_midges
midis85923413_mid_is
mids76541793_mid__s
midsole1037813_midsole
midsoles1137763_midsoles
midsts95510053_midsts
mills75435053_mi_lls
milos75428013_milo_s
mils66045333_mi__ls
minors85117103_minors
misdoes10312493_misdoes
misos76523293_miso_s
modals93914463_modals
models94216363_models
mols65948573_m__ols
mools76027173_m_ools
nicols8810243_nicols
ominous949033ominous
quinols16297243quinols
samiels939763sami_els
seidels838393seidels
skidoos1234463skidoos
smidges11448193smidges
thiols95112763thi_ols
triols66117803tri_ols
viols86118103_vi_ols
widows1376563_widows

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.403443402.0
2DLD Change Limit1340271726.62620227.4
3Display Results1721720.0632730.2
 (SQL Overall)1786911727.09225196.1
 
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.