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

207 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
amidol948957(None) 
amido85720981amido_
amidols10457561amidols
aldol61212332a_ldol
amadou977612amadou
amatol838692amatol
amid77036352amid__
amide86128482amid_e
amides95722662amides
amidic114012872amidic
amidin94015672amidin
amidone10349312amidone
amids85627512amid_s
amidst94913232amidst
amigo86515472amigo_
amigos94511212amigos
amino75425502amino_
azido155411542azido_
idol56818632__idol
imido85812242imido_
abide86223713abid_e
abided105313313abided
abider95314463abider
abides94719893abides
acid77533393acid__
acidic113612133acidic
acidly125211793acidly
acids87121003acid_s
acidy117214893acid_y
adios65822863adi_os
admiral1046363admiral
ado49146873a__do_
ados57633513a__dos
agio57828453agi_o_
agios65919863agi_os
aid49269083a_id__
aide56045003a_id_e
aided75828933a_ided
aider65431133a_ider
aides65336603a_ides
aidful1057073a_idful
aids57846363a_id_s
aikido1135473aikido_
aikidos1253883aikidos
ail37171043a_i__l
aimful1166703aimful
aioli5318313a_i_oli
aldols7109713a_ldols
alidad838883alidad
aliyos9349533aliyos
aliyot93611713aliyot
aludel747863aludel
amadous1038503amadous
amatols938183amatols
amazon1736833amazon
ambo88225143am_bo_
ambos95321253am_bos
ami56646813ami___
amia66836903ami__a
amiable11312033amiable
amiably1438303amiably
amias75831473ami_as
amice96122873ami_ce
amices105018013amices
amici94217393ami_ci
amicus103810003amicus
amidase1036733amidase
amidine103613853amidine
amidins103713103amidins
amidogen1243913amidogen
amidones11348663amidones
amie66339853ami__e
amies76837693ami_es
amiga85514813ami_ga
amigas95912173amigas
amin66042253ami__n
amine75835383ami_ne
amines84727983amines
aminic104413513aminic
amins75534323ami_ns
amir65129753ami__r
amirs75924923ami_rs
amis66445323ami__s
amiss75823073ami_ss
amitrole1045173amitrole
amity10416093ami_ty
ammino1069883ammino_
ammo85520133am_mo_
ammos94815823am_mos
amnio75218053amnio_
amnion84812053amnion
amnios84912523amnios
amok10217403am__ok
amole75724593am__ole
amoral8314633amoral
ampul91110853am_pul
amyl95515103am__yl
anil46437433ani__l
animal85016253animal
anion55028813ani_on
anisole71010833anisole
anodal72512123anodal
apical10913903apical
apodal9289833apodal
apsidal1046703apsidal
ardor64617863a_rdor
argol65317263a_rgol
arid57642713arid__
arider74717743arider
aridly105513703aridly
ariel55228973ari_el
aril45843023ari__l
aside65122083asid_e
asides75118873asides
audial7312993audial
audio62917103audio_
audios72312283audios
avid88325963avid__
avidin103510843avidin
avidly13548783avidly
avion84218343avi_on
aviso85713963aviso_
avisos95410483avisos
awol75620673a__wol
axial124515193axi_al
axil116424453axi__l
axiom143913593axi_om
axion1211316913axi_on
azide155617163azid_e
azides165113803azides
bridal9511453bridal
camion103917193cami_on
camisole1246173camisole
camphol1645793camphol
capitol11258283capitol
cibol9512023_cibol
dido66528203_dido_
didos76820813_didos
diol57329133_di_ol
dol47150653___dol
eidola737683_eidola
eidos65817753_eidos
fido87726403_fido_
fidos95819053_fidos
frijol1634123frijol
frivol1235113frivol
gambol1138223gam_bol
guidon837373guidon
halidom1386443halidom
humidor1343533humidor
idols65514133__idols
idyl85912303__idyl
imid76122293imid__
imide85716893imid_e
imides94515343imides
imidic11358203imidic
imids86015143imid_s
imino74315233imino_
indol63714873_indol
laminal94113633laminal
lido56028163_lido_
lidos65219883_lidos
maid75537663maid__
maiden93512283maiden
maids86327143maid_s
mail65543453mai__l
maill74420793mai_ll
maltol8310843maltol
mandola1039023mandola
medal86221333_medal
metol75917813_metol
miaou7513083_miaou
miaow1058353_miaow
miaul71612123_miaul
mid67354473_mid__
middle103414983_middle
middy124812593_middy
midge95016553_midge
midi75628483_mid_i
midis85923413_midis
mids76541793_mid_s
midsole1037813_midsole
midst85922553_midst
mil55752113_mi__l
mill66541483_mi_ll
milo65536103_milo_
milos75428013_milos
minor74920063_minor
misdo85413183_misdo_
miso67229903_miso_
misos76523293_misos
modal85919243_modal
model84521693_model
mol56654593_m__ol
mool67533863_m_ool
nicol71113293_nicol
nidal65217103_nidal
quinol15357973quinol
samiel8313333sami_el
seidel7311083seidel
skidoo1136093skidoo
smidge10378483smidge
thiol87616043thi_ol
tidal64516443_tidal
triol55521363tri_ol
viol76523593_vi_ol
widow1278933_widow

Search took 6 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 Filter1786911127160.403443402.0
2DLD Change Limit1127162075.26621404.5
3Display Results2072070.0633285.7
 (SQL Overall)1786912075.73231174.3
 
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.