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

146 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
glucans104529(None) 
glucan936181glucan_
glycans1344231glycans
glans65125832gl__ans
gleans75014742gl_eans
glucagons1341902glucagons
gluons738502glu_ons
glutens8437592glutens
glycan1234902glycan_
glycins1335562glycins
guans64419442g_u_ans
toucans937582toucans
aglycons1442973aglycons
alans55636173al__ans
alumins9512983alumins
anurans73810553anurans
ashcans1235183ashcans
bluecaps1442513bluecaps
brucins1158003brucins
burans85019303_burans
cancans11311873cancans
cans65050853___cans
clachans1546413clachans
clans75031013cl__ans
cleans85817053cl_eans
clucks144512073cluc_ks
crucians1245293crucians
ducats95011763_ducats
elans55527753el__ans
eluant6315093elu_ant
eluants737583elu_ants
faucals12326563faucals
flacons1238053flacons
flans85327973fl__ans
furans94515953_furans
garcons102411643garcons
gascons10289103gascons
gauchos1345903gauchos
gelcaps1235203gelcaps
germans1079473germans
glaces94218033glac_es
glacis94012133glac_is
glads75620613gl__ads
glams85822933gl__ams
gland75217713gl__and
glands85314403gl__ands
glass65518133gl__ass
glaucous1144223glaucous
gleams94812253gl_eams
glean65818203gl_ean_
glens66519853gl__ens
glias64618493gl_ia_s
gloams95210663gl_oams
gloats74515423gl_oats
globins10278953globins
glucagon1241823glucagon
glucinic1363743glucinic
glucinum1343203glucinum
glucinums1442293glucinums
glucose1045123glucose
glucoses1145343glucoses
glueing9338713glueing
gluers75011153glu_ers
glues65125683glu__es
glugs75214283glu__gs
gluing83812053glu_ing
glumes94516813glu_mes
glums84621423glu__ms
glunches1436263glunches
gluon6311223glu_on_
gluten74210753gluten_
glutes74517673glu_tes
gluteus8386253gluteus
gluts66120133glu__ts
gluttons944273gluttons
glycin1235963glycin_
glycine1335713glycine
glycines1445083glycines
glycols1344133glycols
glycyls1642063glycyls
gobans94412043g_obans
gossans836783gossans
gowans105512293g_owans
grans64832543g__rans
groans74815063g_roans
guacos94410313g_uacos
guan55325583g_u_an_
guano69213983g_u_ano
guanos73811993g_u_anos
guars65021053g_u_ars
gucks123917303g_uc_ks
gulags837543g_ulags
gulches13398113gulches
guldens9356573guldens
guns55533483g_u__ns
humans112312433_humans
lagans75717783_lagans
lauans65113533_lauans
leans55536253_l_eans
lemans85316393_lemans
leucins938103leucins
ligans76817733_ligans
limans84816303_limans
loans56026463_l_oans
locals83714503_locals
lochans1248833_lochans
logans76319063_logans
lorans65117603_lorans
luaus54514903_lu_aus
lucarne944263_lucarne
lucarnes1045093_lucarnes
lucent8313823_lucent
lucerns935753_lucerns
luces75528433_luc_es
lucks115723563_luc_ks
lucres84513303_lucres
lumas75622913_luma_s
lumens85013973_lumens
lunars65012813_lunars
lunas55025013_luna_s
lungans8399053_lungans
lupins84514463_lupins
lurdans837073_lurdans
mucins102712513_mucins
oilcans936813oilcans
pecans101515833_pecans
pelicans1238093pelicans
plans75731273pl__ans
platans93413123platans
plucks14379733pluc_ks
plurals936913plurals
plutons938343plutons
queans153110753_queans
scans74625103__scans
slogans8407983slogans
soucars938423soucars
soudans8309353soudans
suldans8299723suldans
sultans72411833sultans
toucan838193toucan_
ulans54921303__ulans
ululant747693ululant
wiccans1434603wiccans
yuans84613323_yu_ans
yucas106013913_yuca_s
yulans958673_yulans

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 Filter1786911340270.436409841.7
2DLD Change Limit1340271466.64320175.7
3Display Results1461460.0463173.9
 (SQL Overall)1786911467.12525079.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.