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
anga5683135(None) 
aga410447231a_ga
alga57927601alga
ana39559831an_a
angas65827981angas
anna45529011anna
anoa45634471anoa
ansa45927771ansa
anta46839581anta
fanga96119621fanga
manga85026201manga
panga85323531panga
sanga66023791sanga
tanga64923691tanga
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
and47244172an_d
ands57833612ands
ane37866952an_e
anear55420322anear
anes45255932anes
anew76623132anew
angary10311322angary
angel65019562angel
anger66225872anger
angina7413132angina
angle64528872angle
anglo65215372anglo
angora71111572angora
angry9310862angry
angst6415492angst
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
banda85223102banda
bang74837002bang_
bangs85627772bangs
canna75919332canna
conga85419872conga
dagga839542dagga
dang65131542dang_
dangs75623202dangs
donga76718422donga
eng46726782eng_
engs56121392engs
fanega1055782fanega
fang85432552fang_
fangas105017192fangas
fangs96224072fangs
gaga66625552gaga
gang66031972gang_
gangs76222572gangs
ganja131410002ganja
giga66720942giga
hang85535552hang_
hangar104114512hangar
hangs95726722hangs
hansa85416782hansa
inia45024702inia
juga126417322juga
kana85928532kan_a
lang56637382lang_
linga66820822linga
mana65341962man_a
mangas94122922mangas
mange84930192mange
mango85724322mango
mangy115021242mangy
mania75634152mania
manna75522542manna
manta75629912manta
mega77620872mega
na28652482_n_a
nada58022902nada
nag46450812nag_
nags55436022nags
nala46930392nala
nana46632902nana
napa66927262napa
panda85022612panda
pang75336292pang_
pangas99921102pangas
pangs84628662pangs
raga55930812raga
rang56939162rang_
range64728412range
rangy95320382rangy
ruga56121232ruga
saga55331172saga
saiga64717932saiga
sang55441232sang_
sangar73617682sangar
sangas75222652sangas
sangh95517452sangh
snag55827872snag
taiga64115662taiga
tang56138672tang_
tango66921172tango
tangs65028342tangs
tangy94519932tangy
tanka93817482tanka
toga57027412toga
tonga65619692tonga
vanda94515922vanda
vang84926042vang_
vangs96319582vangs
viga85622962viga
wangan10311222wangan
yang85626072yang_
yangs95618692yangs
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.0632836365.1
2DLD Change Limit298721670.93631914.5
3Display Results1671670.0463630.4
 (SQL Overall)1786911671.045170996.2
 
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.