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
ai211288391a_i
aim57858211aim
am411875561am_
ama510853301ama
amia66836901amia
amid77036341amid
amie66339851amie
amin66042251amin
amir65129751amir
amis66445321amis
amp77541021amp
amu58237321amu
ani37751171ani
kami105823641kami
mi48249051_mi
rami66034091rami
aa219179952a_a
aah616252962aah
aal39058672aal
aas310975392aas
ab410674762a_b
aba512850952aba
abo59045962abo
abri65522212abri
abs59356072abs
aby810238062aby
ace59656832ace
acid77533392acid
acme86924322acme
acmic11312332acmic
act59557842act
ad311975032a_d
add510132362add
adit56443652adit
admit8319492admit
admix1557722admix
ado49146872ado
ads49755732ads
adz1312332862adz
ae212590292a_e
aff95537612aff
aft66849012aft
ag311067462a_g
aga410447232aga
age47154332age
agin56132712agin
agio57828452agio
agma77623262agma
ago48845522ago
ags47551662ags
ah513868792a_h
aha611246642aha
ahis76135382ahis
ahs68644822ahs
aid49269072aid
ail37171042ail
aims67738182aims
ain37579092ain
air38058392air
ais39083572ais
ait38093902ait
akin86328032akin
al210674042a_l
ala312463602ala
alb57342652alb
ale36572342ale
alif76242142alif
alit46155692alit
all36148232all
alma66333022alma
alme65832162alme
alms65834922alms
alp56641132alp
als36663022als
alt36467962alt
amah98927482amah
amain74922892amain
amas67746292amas
ambit94223712ambit
ambo88225142ambo
amen66733152amen
amias75831472amias
amice96122872amice
amici94217392amici
amide86128482amide
amido85720972amido
amids85627512amids
amies76837692amies
amiga85514802amiga
amigo86515462amigo
amine75835382amine
amino75425502amino
amins75534322amins
amirs75924922amirs
amiss75823072amiss
amity10416092amity
ammo85520132ammo
amnia75918642amnia
amnic95516242amnic
amnio75218052amnio
amok10217402amok
amps86230342amps
amus65529612amus
amyl95515092amyl
an211879072a_n
ana39559822ana
and47244162and
ane37866942ane
anil46437432anil
animi74016662animi
anis45746462anis
ant37270782ant
anti45536362anti
any68440482any
ape57251182ape
apo511142122apo
app76827602app
apt57352542apt
ar211379382a_r
arb510448422arb
arc510250902arc
are37874572are
arf67453372arf
aria46245422aria
arid57642712arid
aril45843022aril
ark77044962ark
arm58449622arm
arms66137492arms
army96624182army
ars37670932ars
art38679142art
as211083072a_s
asci66519142asci
ash67944602ash
ask77130702ask
asp57235342asp
ass37844062ass
at212393402a_t
ate37059242ate
atma68121772atma
att35454652att
auk76234142auk
ava610139322ava
ave67748702ave
avid88325962avid
avo68936232avo
aw512563402a_w
awa611939672awa
awe67746622awe
awl67635302awl
awn68035912awn
ax911057782a_x
axe108239492axe
axil116424452axil
axis116127912axis
ay511773892a_y
aye67151762aye
ayin76331742ayin
ays67050292ays
azo128233392azo
bam78560142bam_
bams87044452bams
bani65334952bani
bi48046472_bi
cadi75732172cadi
cam78058982cam_
came87648752came
camo85731752camo
camp106336452camp
campi116217782campi
cams87047282cams
chi86228652chi
dam67457042dam_
dame77140312dame
damn75724322damn
damp96228842damp
dams77444372dams
dim68146492dim
dui46433382dui
em49445152em_
eme55837182eme
emic86422752emic
emir65918702emir
emit65438422emit
ems56435492ems
emu55929982emu
fame95639392fame
gadi66329722gadi
gam67060062gam_
gama77035512gama
gamb96331842gamb
game76644322game
gamic103916192gamic
gamin84422992gamin
gamp98833212gamp
gams76648882gams
gamy105427532gamy
ghi77019882ghi
haji148520182haji
ham86363282ham_
hame97043132hame
hams96446132hams
hi57947582_hi
him86247652him
hm78126732hm_
hmm106218992hmm
iamb86623732iamb
iambi95512212iambi
imid76122292imid
imp76626972imp
impi85415792impi
jam126942522jam_
jamb155523852jamb
jams135231072jams
kadi96224822kadi
kaki76520912kaki
kame105728232kame
kamik105011552kamik
khi106318302khi
ki67537952_ki
koi77534742koi
lam57666712lam_
lama66635292lama
lamb86832142lamb
lame66849292lame
lamia75324322lamia
lamp86233822lamp
lams66552262lams
lari45839152lari
lati46438272lati
lei36846382lei
li29948752_li
ma410060652_ma
mac78053922mac
mad68958702mad
mae57659102mae
mag67956472mag
magi76329522magi
maid75537642maid
mail65543442mail
maim85831482maim
main65345512main
mair66133772mair
mama86231582mama
mamie95826002mamie
man57465852man
map77255112map
mar57965942mar
mas58175812mas
mat58083932mat
maw87050092maw
max129045442max
maxi137023552maxi
may88757622may
me47748332_me
mib76946122_mib
mic77647642_mic
mid67354462_mid
mig65646082_mig
mil55752112_mil
mim76048422_mim
mir57046772_mir
mis58162622_mis
mix126138182_mix
mm67826812_mm
mo49158482_mo
momi87524482momi
mu46737482_mu
my78125652_my
nam55953392nam_
name65637412name
naoi46024632naoi
nazi136219872nazi
nim57142952nim
obi57127732obi
oi29061482_oi
om48553002om_
omit65337372omit
oms56337512oms
padi76331782padi
pam77858392pam_
pams85641762pams
phi86524202phi
pi48145362_pi
poi57244662poi
psi56621622psi
qadi145621102qadi
qi116526902_qi
ragi56032282ragi
rai37658222rai
raki87127832raki
ram56867272ram_
ramie75027822ramie
ramp85934002ramp
rams65950772rams
rani46640102rani
rei35647252rei
rim56052272rim
sadi55834642sadi
saki85628472saki
salmi7815862salmi
same65245642same
samp85733592samp
sari45444042sari
sati45539322sati
sei36048932sei
semi65127222semi
si29149572_si
sim56553132sim
ski74925682ski
smit65138412smit
sri35634002sri
swami105614522swami
tali46837162tali
tam58663422tam_
tame66343662tame
tamis76728722tamis
tamp86133002tamp
tams67247932tams
taxi117124762taxi
ti28448292_ti
tui37034022tui
um47338832um_
umami939882umami
umm711921262umm
ump76130442ump
vagi86719362vagi
vamp115521542vamp
vim87437022vim
wadi86228172wadi
wame95035482wame
xi98128162_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.0632836365.1
2DLD Change Limit140843390.34341061.2
3Display Results3393390.0635381.0
 (SQL Overall)1786913390.469381004.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.