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 “amid” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

202 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
amid7703636(None) 
acid77533401acid
aid49269091a_id
ami56646811ami_
amia66836901amia
amide86128491amide
amido85720991amido
amids85627521amids
amie66339851amie
amin66042251amin
amir65129751amir
amis66445321amis
arid57642721arid
avid88325971avid
imid76122301imid
maid75537671maid
mid67354481_mid
abed79734132abed
abide86223722abide
aced79540882aced
acids87121012acids
acidy117214902acidy
acmic11312332acmic
acrid86920102acrid
ad311975042a__d
add510132372a_dd
adit56443662adit
admit8319492admit
admix1557732admix
agamid103710692agamid
aged67334252aged
agin56132712agin
agio57828452agio
ahed89536252ahed
ahi68040232ahi_
ahis76135382ahis
ai211288402a_i_
aide56045012a_ide
aids57846372a_ids
ail37171052a_il
aim57858222a_im
aimed85626052aimed
aims67738192aims
ain37579102a_in
air38058402a_ir
ais39083582a_is
ait38093912a_it
akin86328042akin
alcid85817972alcid
algid75415582algid
alif76242142alif
alit46155692alit
almud84012182almud
am411875562am__
ama510853312am_a
amah98927502amah
amain74922912amain
amas67746302amas
ambit94223712ambit
ambo88225142ambo
amen66733152amen
amend85717752amend
amias75831472amias
amice96122872amice
amici94217392amici
amides95722662amides
amidic114012872amidic
amidin94015672amidin
amidol9489572amidol
amidst94913232amidst
amies76837692amies
amiga85514812amiga
amigo86515472amigo
amine75835382amine
amino75425502amino
amins75534322amins
amirs75924922amirs
amiss75823072amiss
amity10416092amity
ammo85520132ammo
amnia75918642amnia
amnic95516242amnic
amnio75218052amnio
amok10217402amok
amp77541022am_p
amped104820512amped
amps86230342amps
amu58237322am_u
amus65529612amus
amyl95515102amyl
and47244182a_nd
ani37751182ani_
anil46437432anil
anis45746472anis
aped78538152aped
aphid115515392aphid
apod78123182apod
aramid93315612aramid
aria46245432aria
aril45843022aril
armed86324442armed
aroid65428342aroid
aside65122092aside
auld54125362auld
avoid95516682avoid
awed88436032awed
axed128829612axed
axil116424452axil
axis116127912axis
ayin76331742ayin
azide155617172azide
azido155411552azido
bid67751822_bid
caid77837542caid
canid85526342canid
chid106626412chid
did56850532_did
emic86422752emic
emir65918702emir
emit65438422emit
emyd1047072emyd
famed115928342famed
fid76847702_fid
gadid85517382gadid
gamed95126392gamed
gamic103916202gamic
gamin84423002gamin
gid57047282_gid
grid65829622grid
guid66022832guid
halid94424982halid
hid76248392_hid
humid114213762humid
id38941852__id
imide85716902imide
imido85812252imido
imids86015152imids
irid55927182irid
kami105823662kami_
kamik105011562kamik
kid86540632_kid
laid56439152laid
lamed85235292lamed
lamia75324322lamia
lid47453532_lid
loid55531502loid
mad68958722_mad
maids86327152maids
mail65543452mail
maim85831492maim
main65345522main
mair66133782mair
mamie95826002mamie
maud75325402maud
med66146752_med
mi48249062_mi_
mib76946132_mib
mic77647652_mic
midi75628492_midi
mids76541802_mids
mig65646092_mig
mil55752122_mil
mild75330862_mild
mim76048432_mim
mind75434392_mind
mir57046782_mir
mis58162632_mis
mix126138192_mix
mod69054412_mod
mud67336872_mud
named85223062named
omit65337372omit
oxid12815492oxid
paid75737492paid
pavid115717002pavid
qaid146023852qaid
quid144922362quid
rabid84520782rabid
raid55243082raid
rami66034092rami_
ramie75027822ramie
ranid66429332ranid
rapid86422032rapid
rid46754642_rid
said55742122said
sapid84720932sapid
sayid95516722sayid
skid95720942skid
slid55828992slid
smit65138412smit
tabid84418262tabid
tamed85528512tamed
tamis76728732tamis
timid84815732timid
tumid84114022tumid
valid94618392valid
vapid115614282vapid
vid77241822_vid
void86220572void
whid115418882whid
yid76640842_yid
zamia165115212zamia

Search took 2 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 Filter178691298720.343520965.0
2DLD Change Limit298722020.97030795.9
3Display Results2022020.0603366.7
 (SQL Overall)1786912021.373130146.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.