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

196 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
amia6683690(None) 
ama510853301am_a
ami56646811ami_
amias75831471amias
amid77036351amid
amie66339851amie
amiga85514811amiga
amin66042251amin
amir65129751amir
amis66445321amis
amnia75918641amnia
aria46245421aria
lamia75324321lamia
zamia165115211zamia
aa219179952a__a
aba512850952a_ba
abba810522652abba
acid77533392acid
acmic11312332acmic
acta69524802acta
adit56443652adit
admit8319492admit
admix1557732admix
aecia73819282aecia
aga410447232a_ga
agha87417302agha
agin56132712agin
agio57828452agio
agita6315422agita
agma77623262agma
agria65517142agria
aha611246642a_ha
ahi68040232ahi_
ahis76135382ahis
ai211288392a_i_
aid49269082a_id
ail37171042a_il
aim57858212a_im
aims67738182aims
ain37579092a_in
air38058392a_ir
ais39083572a_is
ait38093902a_it
ajiva1586802ajiva
akin86328032akin
ala312463602a_la
alba68328332alba
alfa77624272alfa
alga57927602alga
alias55834602alias
alif76242142alif
alit46155692alit
aliya83713482aliya
alma66333022alma
am411875562am__
amah98927492amah
amain74922912amain
amas67746292amas
ambit94223712ambit
ambo88225142ambo
ameba9312382ameba
amen66733152amen
amice96122872amice
amici94217392amici
amide86128482amide
amido85720982amido
amids85627512amids
amies76837692amies
amigas95912172amigas
amigo86515472amigo
amine75835382amine
amino75425502amino
amins75534322amins
amirs75924922amirs
amiss75823072amiss
amity10416092amity
ammo85520132ammo
amnic95516242amnic
amnio75218052amnio
amok10217402amok
amp77541022am_p
amps86230342amps
amrita8411132amrita
amu58237322am_u
amus65529612amus
amusia839172amusia
amyl95515102amyl
ana39559832a_na
anemia82613572anemia
anga56831352anga
ani37751182ani_
anil46437432anil
anima74620072anima
anis45746462anis
anna45529012anna
anoa45634472anoa
ansa45927772ansa
anta46839582anta
apian75018332apian
aqua132813962aqua
area45843392area
arias55438022arias
arid57642712arid
aril45843022aril
asea46327182asea
atma68121772atma
atria56022342atria
aura45836252aura
ava610139322a_va
avian84616052avian
avid88325962avid
awa611939672a_wa
axial124515192axial
axil116424452axil
axis116127912axis
ayin76331742ayin
bima86723832bima
cambia124913152cambia
camisa103114322camisa
chia96026622chia
emic86422752emic
emir65918702emir
emit65438422emit
facia103218462facia
gama77035522gam_a
gamba106018512gamba
gambia115912252gambia
gamic103916202gamic
gamin84423002gamin
gamma106116102gamma
glia56423152glia
hamza19139772hamza
ilia46026822ilia
imid76122292imid
inia45024702inia
ixia115713212ixia
kalmia1238892kalmia
kami105823642kami_
kamik105011552kamik
labia75219012labia
lama66635292lam_a
lamiae84817452lamiae
lamias85020612lamias
lamina84920442lamina
lima65734132lima
ma410060662_m_a
mafia104418032mafia
maid75537662maid
mail65543452mail
maim85831492maim
main65345522main
mair66133782mair
mama86231592mama
mamba116317522mamba
mamie95826002mamie
mamma86317912mamma
mana65341962mana
mania75634152mania
mara67444572mara
maria75032882maria
masa65034722masa
maya95824592maya
mi48249052_mi_
mib76946122_mib
mic77647642_mic
mica86428252_mica
mid67354472_mid
mig65646082_mig
mil55752112_mil
mim76048422_mim
mina65136922_mina
mir57046772_mir
mis58162622_mis
mix126138182_mix
moa57249182_moa
obia67923112obia
ohia75719362ohia
omit65337372omit
pampa114913422pampa
pia56848032_pia
pima85428652pima
raia46638382raia
rami66034092rami_
ramie75027822ramie
ria36745502_ria
samba95618772samba
sima64730782sima
smit65138412smit
tafia84215492tafia
tamis76728732tamis
umiac938962umiac
umiak1137672umiak
umiaq1656822umiaq
varia85824202varia
via65636242_via
zamias174212922zamias

Search took 3 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.563317390.8
2DLD Change Limit298721961.87315948.7
3Display Results1961960.0932107.5
 (SQL Overall)1786911962.52970656.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.