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

138 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
manga8502620(None) 
anga56831351_anga
fanga96119621fanga
mana65341961man_a
mangas94122921mangas
mange84930191mange
mango85724321mango
mangy115021241mangy
mania75634151mania
manna75522541manna
manta75629911manta
panga85323531panga
sanga66023791sanga
tanga64923691tanga
aga410447232_a_ga
alga57927602_alga
amiga85514812amiga
amnia75918642amnia
ana39559832_an_a
angas65827982_angas
anna45529012_anna
anoa45634472_anoa
ansa45927772_ansa
anta46839582_anta
banda85223102banda
bang74837002bang_
bangs85627772bangs
canna75919332canna
conga85419872conga
dagga839542dagga
dang65131542dang_
dangs75623202dangs
donga76718422donga
fanega1055782fanega
fang85432552fang_
fangas105017192fangas
fangs96224072fangs
gaga66625552ga_ga
gang66031972gang_
gangs76222572gangs
ganja131410002ganja
hang85535552hang_
hangar104114512hangar
hangs95726722hangs
hansa85416782hansa
kana85928532kan_a
lang56637382lang_
linga66820822linga
mafia104418032mafia
mag67956482ma_g_
mage75739132ma_ge
magi76329532ma_gi
magma104513572magma
mags75444532ma_gs
malanga1036662malanga
mama86231592ma_ma
mamba116317522mamba
mamma86317912mamma
man57465872man__
manage93818902manage
manana84816072manana
manas76240432manas
manat76039992manat
mane65052032man_e
maned86634102maned
manege94113202manege
manes76648962manes
mangaby1535352mangaby
mangel94017532mangel
manger94325002manger
manges94628942manges
mangey123614522mangey
mangle93921322mangle
mangos94319332mangos
maniac103917972maniac
manias84029032manias
manic94629442manic
manila84518302manila
manly105022952manly
mannan85413622mannan
mannas85019802mannas
mano66536812man_o
manor78023932manor
manos74933622manos
mans66354552man_s
manse75528232manse
mantas85725362mantas
mantra84116092mantra
mantua84412022mantua
manual8313462manual
manus75924932manus
many95731862man_y
mara67444572ma_ra
margay12310592margay
marge85328332marge
maria75032882maria
marka114620792marka
masa65034722ma_sa
massa75518922massa
matza16311812matza
maya95824592ma_ya
mega77620872m_ega
mensa75318662mensa
menta74424422menta
mina65136922min_a
mingy115520182mingy
mongo810122412mongo
mungo84916052mungo
myna95815302myn_a
nana46632902nan_a
panda85022612panda
pang75336292pang_
pangas99921102pangas
pangs84628662pangs
raga55930812ra_ga
rang56939162rang_
range64728412range
rangy95320382rangy
saga55331172sa_ga
saiga64717932saiga
sang55441232sang_
sangar73617682sangar
sangas75222652sangas
sangh95517452sangh
taiga64115662taiga
tang56138672tang_
tango66921172tango
tangs65028342tangs
tangy94519932tangy
tanka93817482tanka
tonga65619692tonga
vanda94515922vanda
vang84926042vang_
vangs96319582vangs
wangan10311222wangan
yang85626072yang_
yangs95618692yangs
zanza1378702zanza

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 Filter178691538000.313570897.8
2DLD Change Limit538001381.65632487.9
3Display Results1381380.0304600.0
 (SQL Overall)1786911381.99989390.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.