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 “ganglia” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

141 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
ganglia94661(None) 
ganglial1054661ganglial
gangliar1064121gangliar
gangliate1144492gangliate
ganglier1047602ganglier
gangling112411402gangling
ganglion1044392ganglion
gangly113911582gangl_y
gangsta944512gangsta
sangria838112sangria
abelia83114403_abelia
abulia83512503_abulia
agnosia837643agnosia
agria65517143_a_gria
analgia898363_analgia
anemia82613573_anemia
anga56831353_ang__a
angaria8311583_angaria
angelic1039623_angelic
angelica1145893_angelica
angina7413133_angina
angle64528873_angl_e
angled84219093_angled
angler74017863_angler
angles74426703_angles
anglice1089213_anglice
angling92816043_angling
anglo65215373_angl_o
anglos74413913_anglos
angora71111573_angora
anilin6417793_anilin
anopia83412393_anopia
anoxia133510023_anoxia
anuria6313123_anuria
bangle94018953bangl_e
bangles103617413bangles
banksia1335943banksia
camelia11510433camelia
canella9310793canella
canola8313623canol_a
canula8312963canul_a
dahlia1035773da_hlia
dangle84119303dangl_e
dangled104013153dangled
dangler96912813dangler
dangles93618423dangles
danglier1056753danglier
dangling112611233dangling
dangly114212263dangl_y
fanga96119623fang__a
fanglike1636823fanglike
gaga66625553ga_g__a
gaggle93412623gaggl_e
gaggled11359913gaggled
gaggles103512593gaggles
gaggling10217463gaggling
gala55635163ga__l_a
galabia1038333galabia
galea64722943ga__lea
gallic9411643ga_llic
gallica1047463ga_llica
gambia115912253ga_mbia
gang66031973gang___
ganged94619193gang_ed
ganger83721463gang_er
gangers94418603gangers
ganging103216193ganging
gangland1145193gangland
gangliest1137673gangliest
ganglions1144063ganglions
gangplow1541603gangplow
gangrel996143gangrel
gangs76222573gang__s
gangstas1044403gangstas
gangue81310573gang_ue
gangues9149753gangues
gangway1544233gangway
ganja131410003gan__ja
ganoid8314443gan_oid
gantlet83616243gantlet
gantline9410903gantline
gargle84215463gargl_e
gargled104210673gargled
gargler93710263gargler
gargles94214893gargles
gargling11239203gargling
garlic9310043ga_rlic
gaslit7513503ga_slit
gazania1746123gazania
gingeli9286153gingeli_
gingelis10247093gingelis
gingili9306033gingili
gingilis10255593gingilis
gingiva1253293gingiva
glia56423153___glia
gonglike1455423gonglike
gonia64117533gon__ia
gonidia975903gonidia
granola837913granol_a
gynecia1384233gynecia
jangle144416293jangl_e
jangled164111563jangled
jangler153811833jangler
jangles154015683jangles
janglier1656113janglier
jangling17249623jangling
jangly174310603jangl_y
langley1147453langley
languid936623languid
lanolin7310643lanolin
magnolia1144793magnolia
manga85026203mang__a
mangily1339753mangily
mangle93921323mangl_e
mangled113615263mangled
mangler103215643mangler
mangles104021463mangles
mangling122312623mangling
mania75634153man__ia
manila84518303manil_a
manilla93012473manilla
pallia83015593pa_llia
panga85323533pang__a
pangolin1147773pangolin
ranula6311813ranul_a
sanga66023793sang__a
sangrias938373sangrias
tanga64923693tang__a
tangle74019953tangl_e
tangled94214633tangled
tangler83515073tangler
tangles83920043tangles
tanglier948073tanglier
tangling101712543tangling
tangly104413913tangl_y
vanilla10238743vanilla
wangle103817503wangl_e
wangled123312413wangled
wangler113312653wangler
wangles113416933wangles
wangling132310993wangling

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271416.50020619.5
3Display Results1411410.0463065.2
 (SQL Overall)1786911416.93625762.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.