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
amid7703635(None) 
acid77533391acid
aid49269081a_id
ami56646811ami_
amia66836901amia
amide86128481amide
amido85720981amido
amids85627511amids
amie66339851amie
amin66042251amin
amir65129751amir
amis66445321amis
arid57642711arid
avid88325961avid
imid76122291imid
maid75537661maid
mid67354471_mid
abed79734132abed
abide86223712abide
aced79540882aced
acids87121002acids
acidy117214892acidy
acmic11312332acmic
acrid86920102acrid
ad311975032a__d
add510132362a_dd
adit56443652adit
admit8319492admit
admix1557732admix
agamid103710692agamid
aged67334252aged
agin56132712agin
agio57828452agio
ahed89536252ahed
ahi68040232ahi_
ahis76135382ahis
ai211288392a_i_
aide56045002a_ide
aids57846362a_ids
ail37171042a_il
aim57858212a_im
aimed85626052aimed
aims67738182aims
ain37579092a_in
air38058392a_ir
ais39083572a_is
ait38093902a_it
akin86328032akin
alcid85817972alcid
algid75415582algid
alif76242142alif
alit46155692alit
almud84012182almud
am411875562am__
ama510853302am_a
amah98927492amah
amain74922912amain
amas67746292amas
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
and47244172a_nd
ani37751182ani_
anil46437432anil
anis45746462anis
aped78538152aped
aphid115515392aphid
apod78123182apod
aramid93315612aramid
aria46245422aria
aril45843022aril
armed86324432armed
aroid65428342aroid
aside65122082aside
auld54125362auld
avoid95516682avoid
awed88436032awed
axed128829612axed
axil116424452axil
axis116127912axis
ayin76331742ayin
azide155617162azide
azido155411542azido
bid67751812_bid
caid77837532caid
canid85526342canid
chid106626402chid
did56850522_did
emic86422752emic
emir65918702emir
emit65438422emit
emyd1047072emyd
famed115928342famed
fid76847692_fid
gadid85517382gadid
gamed95126392gamed
gamic103916202gamic
gamin84423002gamin
gid57047272_gid
grid65829612grid
guid66022822guid
halid94424982halid
hid76248382_hid
humid114213762humid
id38941842__id
imide85716892imide
imido85812242imido
imids86015142imids
irid55927172irid
kami105823642kami_
kamik105011552kamik
kid86540622_kid
laid56439142laid
lamed85235292lamed
lamia75324322lamia
lid47453522_lid
loid55531492loid
mad68958712_mad
maids86327142maids
mail65543452mail
maim85831492maim
main65345522main
mair66133782mair
mamie95826002mamie
maud75325402maud
med66146742_med
mi48249052_mi_
mib76946122_mib
mic77647642_mic
midi75628482_midi
mids76541792_mids
mig65646082_mig
mil55752112_mil
mild75330852_mild
mim76048422_mim
mind75434382_mind
mir57046772_mir
mis58162622_mis
mix126138182_mix
mod69054402_mod
mud67336862_mud
named85223062named
omit65337372omit
oxid12815482oxid
paid75737482paid
pavid115717002pavid
qaid146023842qaid
quid144922352quid
rabid84520782rabid
raid55243072raid
rami66034092rami_
ramie75027822ramie
ranid66429332ranid
rapid86422032rapid
rid46754632_rid
said55742112said
sapid84720932sapid
sayid95516722sayid
skid95720932skid
slid55828982slid
smit65138412smit
tabid84418262tabid
tamed85528512tamed
tamis76728732tamis
timid84815732timid
tumid84114022tumid
valid94618392valid
vapid115614282vapid
vid77241812_vid
void86220562void
whid115418872whid
yid76640832_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.283631417.0
2DLD Change Limit298722020.84335435.3
3Display Results2022020.0464391.3
 (SQL Overall)1786912021.172152466.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.