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

167 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
anga5683136(None) 
aga410447231a_ga
alga57927601alga
ana39559831an_a
angas65827991angas
anna45529011anna
anoa45634471anoa
ansa45927771ansa
anta46839581anta
fanga96119631fanga
manga85026211manga
panga85323541panga
sanga66023801sanga
tanga64923711tanga
aa219179952a__a
aba512850952a_ba
abba810522652abba
acta69524802acta
ag311067462a_g_
agar58726412a_gar
agas55938842a_gas
age47154332a_ge
agha87417302agha
agma77623262agma
ago48845522a_go
ags47551662a_gs
aha611246642a_ha
ajuga1335882ajuga
ala312463602a_la
alba68328332alba
alfa77624272alfa
algae65319622algae
algal66518222algal
algas65624932algas
alma66333022alma
ama510853302a_ma
amia66836902amia
amiga85514812amiga
amnia75918642amnia
an211879082an__
anal48037522anal
anas46649862anas
and47244182an_d
ands57833622ands
ane37866952an_e
anear55420322anear
anes45255932anes
anew76623132anew
angary10311322angary
angel65019572angel
anger66225882anger
angina7413132angina
angle64528882angle
anglo65215382anglo
angora71111572angora
angry9310872angry
angst6415502angst
ani37751182an_i
anil46437432anil
anima74620072anima
anis45746462anis
ankh111114412ankh
anlas55626932anlas
annal56520762annal
annas55824882annas
anoas57226492anoas
anon46134852anon
ansae55720972ansae
ant37270792an_t
antae56828292antae
antas55432032antas
ante46538902ante
anti45536362anti
antra56521922antra
ants47243472ants
anus47131112anus
any68440492an_y
apnea73413412apnea
aqua132813962aqua
area45843392area
argal65023392argal
aria46245422aria
asea46327182asea
atma68121772atma
aura45836252aura
ava610139322a_va
avgas96912132avgas
awa611939672a_wa
banda85223112banda
bang74837012bang_
bangs85627782bangs
canna75919332canna
conga85419872conga
dagga839542dagga
dang65131552dang_
dangs75623212dangs
donga76718422donga
eng46726782eng_
engs56121392engs
fanega1055782fanega
fang85432562fang_
fangas105017202fangas
fangs96224082fangs
gaga66625552gaga
gang66031982gang_
gangs76222582gangs
ganja131410002ganja
giga66720952giga
hang85535562hang_
hangar104114522hangar
hangs95726732hangs
hansa85416782hansa
inia45024702inia
juga126417322juga
kana85928542kan_a
lang56637392lang_
linga66820822linga
mana65341962man_a
mangas94122932mangas
mange84930202mange
mango85724332mango
mangy115021252mangy
mania75634152mania
manna75522542manna
manta75629912manta
mega77620872mega
na28652482_n_a
nada58022912nada
nag46450812nag_
nags55436022nags
nala46930392nala
nana46632902nana
napa66927262napa
panda85022612panda
pang75336302pang_
pangas99921112pangas
pangs84628672pangs
raga55930812raga
rang56939172rang_
range64728422range
rangy95320392rangy
ruga56121232ruga
saga55331172saga
saiga64717932saiga
sang55441242sang_
sangar73617692sangar
sangas75222662sangas
sangh95517462sangh
snag55827872snag
taiga64115672taiga
tang56138692tang_
tango66921192tango
tangs65028362tangs
tangy94519952tangy
tanka93817492tanka
toga57027412toga
tonga65619702tonga
vanda94515922vanda
vang84926052vang_
vangs96319592vangs
viga85622972viga
wangan10311232wangan
yang85626082yang_
yangs95618702yangs
yoga87418052yoga
yuga85615422yuga
zanza1378702zanza

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.296603685.8
2DLD Change Limit298721670.95331345.2
3Display Results1671670.0335060.6
 (SQL Overall)1786911671.282139384.6
 
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.