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

119 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
glume8512046(None) 
blume95619891blume
flume106021171flume
glime85620191glime
glue55628491glu_e
glum75825101glum_
glumes94516811glumes
glums84621421glums
glute66020901glute
grume86218161grume
plume94819461plume
alme65832162al_me
alum65227612alum_
alums75720602alums
blame95625492blame
blue65328462blu_e
blumed114313642blumed
blumes105917792blumes
brume95817982brume
clime95720892clime
clue65324532clu_e
clump115517452clump
elude64517622elude
elute54822572elute
flame105124442flame
flue75329852flu_e
fluke125016892fluke
flumed124915262flumed
flumes115119732flumes
flump124614722flump
flute86823752flute
fume96727632_fume
game76644322g_ame
gauge76117902gauge
gaum75726422gaum_
gaumed104610322gaumed
gaums86217072gaums
gauze155712972gauze
geum75424552geum_
geums85414112geums
gimme102411342gimme
glace87420152glace
glade75121962glade
glam76529342glam_
glams85822932glams
glare65222952glare
glaze155418162glaze
glebe85016442glebe
glede75517832glede
glee55239062gl_ee
glide74521592glide
glim76026352glim_
glimed105312282glimed
glimes94717522glimes
glims87417672glims
globe84917012globe
glom75424382glom_
gloms85219782gloms
glove94516292glove
gloze154815982gloze
glued75118362glued
gluer65116772gluer
glues65125682glues
gluey95715262gluey
glug66118012glu_g
glugs75214282glugs
gluier7310262gluier
glumly12356622glumly
glummer12417982glummer
glumpy14527192glumpy
gluon6311222gluon
glut56331292glu_t
glutei7409742glutei
gluten74210752gluten
glutes74517672glutes
gluts66120132gluts
gnome84213952gnome
gouge78220062gouge
grime85021322grime
grue55825712gru_e
grum75625082grum_
grumes94415552grumes
grump105115312grump
gude65423332g_ude
gum67439532g_um_
gums75030942g_ums
illume8298222illume
kluge104910462kluge
lame66849292_lame
lime66244932_lime
lube64731562_lube
luce65132572_luce
lude55331642_lude
luge55531642_luge
lum55542932_lum_
luma65527522_luma
lumen75220902_lumen
lump86531702_lump
lums65734242_lums
lune47140492_lune
lure45142462_lure
lute46341012_lute
luxe115222692_luxe
neume74414402neume
plum85122102plum_
plumb114514072plumb
plumed114412882plumed
plumes104318132plumes
plump115315262plump
plums94619952plums
plumy124213232plumy
relume8313272relume
slime74925752slime
slue45332192slu_e
slum65430512slum_
slump94816632slump
slums74623432slums
spume95817312spume
volume11358272volume

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.313570897.8
2DLD Change Limit538001191.59333772.8
3Display Results1191190.0303966.7
 (SQL Overall)1786911191.93692299.1
 
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.