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

248 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
amie6633985(None) 
ami56646811ami_
amia66836901amia
amice96122871amice
amid77036351amid
amide86128481amide
amies76837691amies
amin66042251amin
amine75835381amine
amir65129751amir
amis66445321amis
mamie95826001mamie
ramie75027821ramie
abbe87627192abbe
abide86223712abide
able66340532able
abye97921002abye
ace59656832a_ce
ache96829822ache
acid77533392acid
acme86924322acme
acmic11312332acmic
acne66625872acne
acre67330772acre
adieu6417422adieu
adit56443652adit
admire949932admire
admit8319492admit
admix1557732admix
adze1412820572adze
ae212590292a__e
aerie54634602aerie
afire86215912afire
age47154332a_ge
agee56241492agee
aggie73415012aggie
agile65122262agile
agin56132712agin
agio57828452agio
ague55725922ague
ahi68040232ahi_
ahis76135382ahis
ai211288392a_i_
aid49269082a_id
aide56045002aide
ail37171042a_il
aim57858212a_im
aimed85626052aimed
aimer75926822aimer
aims67738182aims
ain37579092a_in
air38058392a_ir
ais39083572a_is
ait38093902a_it
ajee115928232ajee
akee85936812akee
akin86328032akin
alae45643752alae
ale36572342a_le
alee46652322alee
alien56425582alien
alif76242142alif
alike95523962alike
aline57243152aline
alit46155692alit
alive85722512alive
alkie95520032alkie
alme65832162alme
aloe45540192aloe
am411875562am__
ama510853302am_a
amah98927492amah
amain74922912amain
amas67746292amas
amaze166016602amaze
amber94523212amber
ambit94223712ambit
amble95924642amble
ambo88225142ambo
ameer75618982ameer
amen66733152amen
amias75831472amias
amices105018012amices
amici94217392amici
amides95722662amides
amido85720982amido
amids85627512amids
amiga85514812amiga
amigo86515472amigo
amines84727982amines
amino75425502amino
amins75534322amins
amirs75924922amirs
amiss75823072amiss
amity10416092amity
ammine10314492ammine
ammo85520132ammo
amnia75918642amnia
amnic95516242amnic
amnio75218052amnio
amok10217402amok
amole75724592amole
amp77541022am_p
amped104820512amped
ample94720302ample
amps86230342amps
amu58237322am_u
amus65529612amus
amuse75920832amuse
amyl95515102amyl
ane37866952a_ne
ani37751182ani_
anil46437432anil
anile54634462anile
anime75423202anime
anis45746462anis
anise55129702anise
anomie83215962anomie
ante46538902ante
ape57251182a_pe
apse67725382apse
are37874572a_re
aria46245422aria
arid57642712arid
ariel55228972ariel
aril45843022aril
arise56436432arise
armies85123692armies
arse46539272arse
aside65122082aside
ate37059242a_te
ave67748702a_ve
avid88325962avid
awe67746622a_we
awee76336642awee
axe108239492a_xe
axil116424452axil
axile126020512axile
axis116127912axis
axite125218252axite
axle116424602axle
aye67151762a_ye
ayin76331742ayin
azide155617162azide
azine146721412azine
barmie103816392barmie
brie65837902brie
came87648752cam_e
camise103319632camise
cammie124615292cammie
cavie104621592cavie
dame77140312dam_e
die46759652_die
dime76237642dime
eme55837182em_e
emic86422752emic
emir65918702emir
emit65438422emit
fame95639392fam_e
famine114318192famine
fie67152442_fie
gambe106219212gambe
game76644322gam_e
gamic103916202gamic
gamier93617932gamier
gamin84423002gamin
gamine94620152gamine
gie47149542_gie
hame97043132ham_e
hie67652702_hie
homie104622532homie
imid76122292imid
imide85716892imide
imine75821062imine
jambe165314752jambe
kame105728232kam_e
kami105823642kami_
kamik105011552kamik
lambie103213672lambie
lame66849292lam_e
lamia75324322lamia
lamiae84817452lamiae
lie38264522_lie
lime66244932lime
mabe85733362mabe
mace87345792mace
made75440242made
mae57659112_mae
mage75739132mage
maid75537662maid
mail65543452mail
maile75232222maile
maim85831492maim
main65345522main
mair66133782mair
maize164618562maize
make105537892make
male66052302male
mamies104626242mamies
mammie94313782mammie
mane65052032mane
mare64759332mare
mate65154222mate
mavie104722562mavie
maze155434982maze
me47748332_m_e
mi48249052_mi_
mib76946122_mib
mic77647642_mic
mice87442232_mice
mid67354472_mid
mien65028362_mien
mig65646082_mig
mike105535292_mike
mil55752112_mil
mile66352572_mile
mim76048422_mim
mime85736402_mime
mine67256172_mine
mir57046772_mir
mire66748232_mire
mis58162622_mis
mise66043582_mise
mite66249412_mite
mix126138182_mix
name65637412nam_e
omit65337372omit
pie55457402_pie
plie65127392plie
ramee74633852ramee
rami66034092rami_
ramies84630462ramies
rime65138882rime
same65245642sam_e
samiel8313332samiel
samite83020602samite
smile74823922smile
smit65138412smit
smite75224872smite
tame66343662tam_e
tamis76728732tamis
tammie104212692tammie
tawie84819812tawie
tie36557532_tie
time66235012time
vie65447632_vie
wame95035482wam_e
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 Limit298722480.79637527.6
3Display Results2482480.0763263.2
 (SQL Overall)1786912481.155154710.8
 
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.