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

121 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
gangliest113767(None) 
dangliest1137171dangliest
jangliest1746381jangliest
tangliest1068421tangliest
angriest9310252_angriest
gainliest1037132gainliest
ganglier1047602ganglie_r
giggliest1234322giggliest
gnarliest10186552gnarliest
goggliest1234062goggliest
jingliest1735972jingliest
jungliest1744922jungliest
kingliest1436522kingliest
mangiest112815902mang_iest
manliest102314942man_liest
rangiest93115982rang_iest
spangliest1345152spangliest
tangiest92915222tang_iest
tingliest1047682tingliest
waggliest1434782waggliest
angles74426703_angl_es_
antsiest8511463_antsiest
auntliest936323auntliest
baggiest123011753ba_ggiest
bangles103617413bangl_es_
cagiest102916433ca_g_iest
canniest10313363can_niest
dandiest103415033dan_diest
dangles93618423dangl_es_
danglier1056753danglie_r
darkliest1435163darkliest
dingiest102915373ding_iest
dungiest102810743dung_iest
earliest82415243ea_rliest
faggiest132910183fa_ggiest
fanciest133612713fan_ciest
fangless1237663fangl_ess
gabbiest1337273ga_bbiest
gadflies1334733gadflies_
gaggles103512593gaggl_es_
gallies84122713ga_llies_
gamiest102816233ga__miest
gammiest13339333ga_mmiest
ganglia946613gangli__a
ganglial1054663gangli_al
gangliar1064123gangli_ar
gangliate1144493gangliate
gangling112411403gangli_ng
ganglion1044393gangli_on
ganglions1144063ganglions
gangues9149753gang_ues_
gantlet83616243gantl_e_t
gantlets9308903gantl_ets
gantlines1039333gantlines_
gantries91413783gantries_
gappiest13259473ga_ppiest
gargles94214893gargl_es_
gassiest93212523ga_ssiest
gaudiest1039393ga_udiest
gauziest1836233ga_uziest
gawkiest16327313ga_wkiest
gentlest93410573gentl_est
ghastliest1443443ghastliest
gingelies11277503gingelies_
ginniest92610513gin_niest
girliest93010403g_irliest
gladliest1135373gladliest
gnattiest1035383gnattiest
godliest1039453g_odliest
goodliest1146393goodliest
googlies1086763googlies_
grisliest1047353grisliest
groggiest1235093groggiest
growliest1335583growliest
grungiest1135803grung_iest
gunkiest132610573gun_kiest
hackliest1836523hackliest
handiest123417773han_diest
handlist12311333handli_st
hangnest12311413hang_nest
hungriest1344543hungriest
jaggiest17289323ja_ggiest
jangles154015683jangl_es_
janglier1656113janglie_r
jiggliest1854183jiggliest
kindliest1436113kindliest
lankiest122912493lan_kiest
lingiest93715263ling_iest
loneliest949443loneliest
mangles104021463mangl_es_
marbliest1336763marbliest
marliest102415183ma_rliest
mingiest113315823ming_iest
naggiest102610013na_ggiest
niggliest1144933niggliest
orangiest1038463orang_iest
paliest93021603pa__liest
palliest102814633pa_lliest
panelist10414503paneli_st
randiest93418773ran_diest
saggiest102812713sa_ggiest
sagiest82617983sa_g_iest
saintliest1046013saintliest
sandiest93218683san_diest
slangiest10129073slang_iest
snaggiest11126673snaggiest
snarliest91810203snarliest
tangles83920043tangl_es_
tanglier948073tanglie_r
tinkliest1336133tinkliest
twangiest1355223twang_iest
ugliest8410153__ugliest
wabbliest16274963wabbliest
waffliest1844233waffliest
wambliest16255153wambliest
wangles113416933wangl_es_
waniest103819113wan__iest
wiggliest1444883wiggliest
wingiest123214283wing_iest
zaniest163214773zan__iest
zingiest182810893zing_iest

Search took 8 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 Filter1786911486410.436409841.7
2DLD Change Limit1486411217.18620684.8
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.66823303.5
 
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.