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

155 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
glums8462142(None) 
alums75720601alums
gaums86217071gaums
geums85414111geums
glams85822931glams
glims87417671glims
gloms85219781gloms
glues65125681glues
glugs75214281glugs
glum75825101glum_
glume85120461glume
glumes94516811glumes
gluts66120131gluts
gums75030941g_ums
lums65734241_lums
plums94619951plums
slums74623431slums
albums10198272albums
algums9208042algums
alms65834922al_ms
alum65227612alum_
arums75517832arums
blams95023852blams
blubs95818152blubs
blues75127042blues
blume95619892blume
blumes105917792blumes
blurs74619082blurs
bums85934592_bums
chums125015832chums
clams95127672clams
clubs95415102clubs
clues74623032clues
clump115517452clump
clumps1215314642clumps
clumsy13326192clumsy
culms95314192culms
doums85417642doums
drums85415872drums
elms67322702el_ms
flams105125012flams
flubs105515442flubs
flues84626922flues
flume106021172flume
flumes115119732flumes
flump124614722flump
flumps135112502flumps
flus75626542flu_s
gams76648882g_ams
gauds75717722gauds
gaum75726422gaum_
gaurs66317992gaurs
gauss65613452gauss
gems75329112g_ems
germs85118872germs
geum75424552geum_
glads75620612glads
glam76529342glam_
glans65125832glans
glass65518132glass
gleams94812252gleams
gleds75417892gleds
glees65027592glees
glens66519852glens
gleys96514852gleys
glias64618492glias
glim76026352glim_
glime85620192glime
glimes94717522glimes
gloams95210662gloams
globs85616402globs
glom75424382glom_
glomus9468092glomus
glooms96211682glooms
glops85619552glops
gloss64319622gloss
glouts74414712glouts
glows95518032glows
glue55628492glu_e
glued75118362glued
gluer65116772gluer
gluers75011152gluers
gluey95715262gluey
glug66118012glu_g
glumly12356622glumly
glumpy14527192glumpy
gluon6311222gluon
gluons738502gluons
glut56331292glu_t
glute66020902glute
glutes74517672glutes
gnus56518002gnu_s
golems939322golems
gorms85619592gorms
gouts64826172gouts
grams85327312grams
grubs86312602grubs
grues65721962grues
grum75625082grum_
grume86218162grume
grumes94415552grumes
grump105115312grump
grumps114510572grumps
gules64831042gules
gulfs94915302gulfs
gulls65222982gulls
gulps84715072gulps
guls55930852g_uls
gum67439532g_um_
guns55533482g_uns
guts56637252g_uts
guvs85816812g_uvs
guys85019642g_uys
gyms107514592g_yms
hums96831422_hums
iglus6609932iglu_s
lams66552262_lams
lues45943552_lues
lugs55233522_lugs
lum55542932_lum_
luma65527522_luma
lumas75622912_lumas
lump86531702_lump
lumps95624982_lumps
luvs75818502_luvs
mums85732772_mums
neums75414252neums
oleums8358782oleums
plugs85213492plugs
plum85122102plum_
plumb114514072plumb
plumbs12459332plumbs
plume94819462plume
plumes104318132plumes
plump115315262plump
plumps124612612plumps
plumy124213232plumy
plus66324832plu_s
rums64833472_rums
scums95017422scums
slams74927902slams
slims75423652slims
slubs74719532slubs
slues54527172slues
slugs64618562slugs
slum65430512slum_
slump94816632slump
slumps104313582slumps
slurs54123372slurs
sluts54523982sluts
solums85211332solums
stums75320082stums
sums65837582_sums
ulus45622562ulu_s
ylems1039262ylems

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 Filter178691538000.296603685.8
2DLD Change Limit538001551.51635488.1
3Display Results1551550.0463369.6
 (SQL Overall)1786911551.85896173.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.