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

107 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
grume8621816(None) 
brume95817981brume
glume85120461glume
grime85021321grime
grue55825711gru_e
grum75625081grum_
grumes94415551grumes
grump105115311grump
arame75026632arame
arum66129032arum_
arums75517832arums
blume95619892blume
brome94421972brome
brumes106417072brumes
brute75321782brute
creme94319322creme
crime94822692crime
crude86018572crude
crumb114313592crumb
crump115616422crump
cruse75726102cruse
drum76521592drum_
drums85415872drums
drupe85012992drupe
druse64817662druse
flume106021172flume
frame105821802frame
frump126912562frump
fume96727632_fume
game76644322g_ame
gauge76117902gauge
gaum75726422gaum_
gaumed104610322gaumed
gaums86217072gaums
gauze155712972gauze
geum75424552geum_
geums85414112geums
gimme102411342gimme
glime85620192glime
glue55628492glu_e
glum75825102glum_
glumes94516812glumes
glums84621422glums
glute66020902glute
gnome84213952gnome
gouge78220062gouge
grace85124542grace
grade75126092grade
gram77034582gram_
grama85620292grama
gramme114210332gramme
gramp106218322gramp
grams85327312grams
grape84824662grape
grate64932882grate
grave94624872grave
graze155820052graze
grebe85114942grebe
gree56641562gr_ee
gride75223592gride
grim76929422grim_
grimed104714092grimed
grimes94619032grimes
grimy114312602grimy
gripe84622962gripe
grope84821612grope
grouse74315022grouse
grove95219332grove
grub77220082gru_b
grubs86312602grubs
grudge9388582grudge
gruel66014742gruel
grues65721962grues
gruff124712142gruff
grumble12349232grumble
grummer12338782grummer
grummet12298872grummet
grumose1035722grumose
grumped13337332grumped
grumps114510572grumps
grumpy14498152grumpy
grunge8359582grunge
grunt65523542grunt
gude65423342g_ude
gum67439532g_um_
gums75030942g_ums
gurge75419782gurge
neume74414402neume
plume94819462plume
prime96525602prime
prude84615972prude
prune75119632prune
rime65138892_rime
rube65532012_rube
rude55632792_rude
rue35549262_ru_e
rule49938422_rule
rum56644642_rum_
rumen74419502_rumen
rump86729082_rump
rums64833472_rums
rune45236302_rune
ruse45938932_ruse
spume95817312spume
truce75118692truce
true46725852tru_e
trump95615122trump

Search took 3 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.606294869.6
2DLD Change Limit538001072.05026243.9
3Display Results1071070.0601783.3
 (SQL Overall)1786911072.71665792.0
 
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.