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

339 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
ami5664681(None) 
ahi68040231ahi
ai211288401a_i
aim57858221aim
am411875561am_
ama510853311ama
amia66836901amia
amid77036361amid
amie66339851amie
amin66042251amin
amir65129751amir
amis66445321amis
amp77541021amp
amu58237321amu
ani37751181ani
kami105823661kami
mi48249061_mi
rami66034091rami
aa219179952a_a
aah616252962aah
aal39058672aal
aas310975392aas
ab410674762a_b
aba512850952aba
abo59045962abo
abri65522212abri
abs59356072abs
aby810238062aby
ace59656832ace
acid77533402acid
acme86924322acme
acmic11312332acmic
act59557842act
ad311975042a_d
add510132372add
adit56443662adit
admit8319492admit
admix1557732admix
ado49146882ado
ads49755742ads
adz1312332872adz
ae212590292a_e
aff95537612aff
aft66849012aft
ag311067462a_g
aga410447232aga
age47154332age
agin56132712agin
agio57828452agio
agma77623272agma
ago48845522ago
ags47551662ags
ah513868792a_h
aha611246642aha
ahis76135382ahis
ahs68644822ahs
aid49269092aid
ail37171052ail
aims67738192aims
ain37579102ain
air38058402air
ais39083582ais
ait38093912ait
akin86328042akin
al210674042a_l
ala312463602ala
alb57342652alb
ale36572342ale
alif76242142alif
alit46155692alit
all36148232all
alma66333032alma
alme65832162alme
alms65834922alms
alp56641132alp
als36663022als
alt36467962alt
amah98927502amah
amain74922912amain
amas67746302amas
ambit94223712ambit
ambo88225142ambo
amen66733152amen
amias75831472amias
amice96122872amice
amici94217392amici
amide86128492amide
amido85720992amido
amids85627522amids
amies76837692amies
amiga85514812amiga
amigo86515472amigo
amine75835382amine
amino75425502amino
amins75534322amins
amirs75924922amirs
amiss75823072amiss
amity10416092amity
ammo85520132ammo
amnia75918642amnia
amnic95516242amnic
amnio75218052amnio
amok10217402amok
amps86230342amps
amus65529612amus
amyl95515102amyl
an211879082a_n
ana39559832ana
and47244182and
ane37866952ane
anil46437432anil
animi74016662animi
anis45746472anis
ant37270792ant
anti45536362anti
any68440492any
ape57251182ape
apo511142122apo
app76827602app
apt57352542apt
ar211379382a_r
arb510448422arb
arc510250902arc
are37874572are
arf67453372arf
aria46245432aria
arid57642722arid
aril45843022aril
ark77044962ark
arm58449632arm
arms66137502arms
army96624192army
ars37670932ars
art38679142art
as211083072a_s
asci66519142asci
ash67944602ash
ask77130702ask
asp57235342asp
ass37844062ass
at212393402a_t
ate37059242ate
atma68121782atma
att35454652att
auk76234142auk
ava610139322ava
ave67748702ave
avid88325972avid
avo68936232avo
aw512563402a_w
awa611939672awa
awe67746622awe
awl67635302awl
awn68035912awn
ax911057782a_x
axe108239492axe
axil116424452axil
axis116127912axis
ay511773892a_y
aye67151762aye
ayin76331742ayin
ays67050292ays
azo128233392azo
bam78560142bam_
bams87044452bams
bani65334962bani
bi48046482_bi
cadi75732192cadi
cam78058982cam_
came87648752came
camo85731752camo
camp106336452camp
campi116217782campi
cams87047282cams
chi86228652chi
dam67457042dam_
dame77140312dame
damn75724322damn
damp96228842damp
dams77444372dams
dim68146502dim
dui46433382dui
em49445152em_
eme55837182eme
emic86422752emic
emir65918702emir
emit65438422emit
ems56435492ems
emu55929982emu
fame95639392fame
gadi66329732gadi
gam67060062gam_
gama77035532gama
gamb96331842gamb
game76644322game
gamic103916202gamic
gamin84423002gamin
gamp98833212gamp
gams76648882gams
gamy105427532gamy
ghi77019882ghi
haji148520192haji
ham86363282ham_
hame97043132hame
hams96446132hams
hi57947592_hi
him86247672him
hm78126732hm_
hmm106218992hmm
iamb86623732iamb
iambi95512222iambi
imid76122302imid
imp76626982imp
impi85415792impi
jam126942522jam_
jamb155523852jamb
jams135231072jams
kadi96224842kadi
kaki76520922kaki
kame105728252kame
kamik105011562kamik
khi106318312khi
ki67537972_ki
koi77534762koi
lam57666712lam_
lama66635302lama
lamb86832142lamb
lame66849292lame
lamia75324322lamia
lamp86233822lamp
lams66552262lams
lari45839152lari
lati46438272lati
lei36846382lei
li29948762_li
ma410060662_ma
mac78053932mac
mad68958722mad
mae57659112mae
mag67956482mag
magi76329532magi
maid75537672maid
mail65543452mail
maim85831492maim
main65345522main
mair66133782mair
mama86231602mama
mamie95826002mamie
man57465872man
map77255122map
mar57965952mar
mas58175822mas
mat58083942mat
maw87050102maw
max129045452max
maxi137023562maxi
may88757632may
me47748332_me
mib76946132_mib
mic77647652_mic
mid67354482_mid
mig65646092_mig
mil55752122_mil
mim76048432_mim
mir57046782_mir
mis58162632_mis
mix126138192_mix
mm67826812_mm
mo49158482_mo
momi87524482momi
mu46737482_mu
my78125652_my
nam55953392nam_
name65637412name
naoi46024632naoi
nazi136219872nazi
nim57142962nim
obi57127732obi
oi29061492_oi
om48553002om_
omit65337372omit
oms56337512oms
padi76331792padi
pam77858392pam_
pams85641762pams
phi86524202phi
pi48145372_pi
poi57244662poi
psi56621622psi
qadi145621112qadi
qi116526912_qi
ragi56032282ragi
rai37658222rai
raki87127832raki
ram56867272ram_
ramie75027822ramie
ramp85934002ramp
rams65950772rams
rani46640112rani
rei35647252rei
rim56052282rim
sadi55834652sadi
saki85628482saki
salmi7815862salmi
same65245642same
samp85733592samp
sari45444042sari
sati45539332sati
sei36048932sei
semi65127222semi
si29149582_si
sim56553152sim
ski74925702ski
smit65138412smit
sri35634002sri
swami105614522swami
tali46837162tali
tam58663422tam_
tame66343662tame
tamis76728732tamis
tamp86133012tamp
tams67247932tams
taxi117124762taxi
ti28448302_ti
tui37034022tui
um47338832um_
umami939882umami
umm711921262umm
ump76130442ump
vagi86719362vagi
vamp115521542vamp
vim87437032vim
wadi86228182wadi
wame95035482wame
xi98128172_xi
yagi86922242yagi
yam87448992yam_
yams95330732yams
zamia165115212zamia

Search took 1 second 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 Filter178691140840.250714764.0
2DLD Change Limit140843390.39036112.8
3Display Results3393390.0804237.5
 (SQL Overall)1786913390.720248181.9
 
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.