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
ana39559821an_a
angas65827981angas
anna45529011anna
anoa45634471anoa
ansa45927771ansa
anta46839581anta
fanga96119621fanga
manga85026191manga
panga85323531panga
sanga66023791sanga
tanga64923681tanga
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
algal66518212algal
algas65624932algas
alma66333022alma
ama510853302a_ma
amia66836902amia
amiga85514802amiga
amnia75918642amnia
an211879072an__
anal48037522anal
anas46649862anas
and47244162an_d
ands57833612ands
ane37866942an_e
anear55420322anear
anes45255932anes
anew76623132anew
angary10311322angary
angel65019562angel
anger66225872anger
angina7413132angina
angle64528872angle
anglo65215362anglo
angora71111572angora
angry9310862angry
angst6415492angst
ani37751172an_i
anil46437432anil
anima74620072anima
anis45746462anis
ankh111114412ankh
anlas55626932anlas
annal56520762annal
annas55824882annas
anoas57226492anoas
anon46134852anon
ansae55720972ansae
ant37270782an_t
antae56828292antae
antas55432032antas
ante46538902ante
anti45536362anti
antra56521922antra
ants47243472ants
anus47131112anus
any68440482an_y
apnea73413412apnea
aqua132813962aqua
area45843392area
argal65023382argal
aria46245422aria
asea46327182asea
atma68121772atma
aura45836252aura
ava610139322a_va
avgas96912132avgas
awa611939672a_wa
banda85223102banda
bang74836992bang_
bangs85627772bangs
canna75919332canna
conga85419872conga
dagga839542dagga
dang65131532dang_
dangs75623202dangs
donga76718422donga
eng46726782eng_
engs56121392engs
fanega1055782fanega
fang85432542fang_
fangas105017192fangas
fangs96224072fangs
gaga66625552gaga
gang66031962gang_
gangs76222572gangs
ganja131410002ganja
giga66720942giga
hang85535542hang_
hangar104114502hangar
hangs95726722hangs
hansa85416782hansa
inia45024702inia
juga126417322juga
kana85928522kan_a
lang56637372lang_
linga66820812linga
mana65341942man_a
mangas94122922mangas
mange84930182mange
mango85724312mango
mangy115021232mangy
mania75634142mania
manna75522532manna
manta75629902manta
mega77620872mega
na28652482_n_a
nada58022902nada
nag46450812nag_
nags55436022nags
nala46930392nala
nana46632892nana
napa66927262napa
panda85022612panda
pang75336282pang_
pangas99921102pangas
pangs84628662pangs
raga55930812raga
rang56939152rang_
range64728412range
rangy95320382rangy
ruga56121232ruga
saga55331172saga
saiga64717932saiga
sang55441222sang_
sangar73617682sangar
sangas75222652sangas
sangh95517452sangh
snag55827872snag
taiga64115652taiga
tang56138662tang_
tango66921172tango
tangs65028342tangs
tangy94519932tangy
tanka93817482tanka
toga57027412toga
tonga65619682tonga
vanda94515922vanda
vang84926032vang_
vangs96319582vangs
viga85622962viga
wangan10311222wangan
yang85626062yang_
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.0762351197.4
2DLD Change Limit298721670.94031778.7
3Display Results1671670.0463630.4
 (SQL Overall)1786911671.062168258.9
 
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.