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

153 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
grumose103572(None) 
glucose1045112glucose
grumble12349232grumble
grume86218162grum__e
grumes94415552grumes_
grumous1086612grumous
grumps114510572grumps_
gummose1235332gummose
plumose1135962plumose
ramose8314402_ramose
rimose8310592_rimose
rugose737282_rugose
strumose1044302strumose
albumose1272633albumose
arenose7311373arenose
ariose64818723ar_iose
arkose104911343ar_kose
arose55832083ar__ose
arums75517833arum_s_
biramose1243933biramose
bromos104213313bromos_
brose75227033br__ose
bruise83412873bru_ise
brume95817983brum__e
brumes106417073brumes_
brumous11107443brumous
comose105016843_comose
cruise84314043cru_ise
crumble133410403crumble
crumbs12409233crumbs_
crummie1336153crummie
crumple13368363crumple
crumps124514343crumps_
crunode1034713crunode
cruse75726103cru__se
crustose1045503crustose
cymose13429653_cymose
drumble12337893drumble
drums85415873drum_s_
druse64817663dru__se
erose55727273er__ose
erugos7347343erugos_
fructose1343663fructose
frumps13479783frumps_
fucose11167683_fucose
gaums86217073gaum_s_
gemote94613023g_emote
geums85414113geum_s_
gibbose1244083gibbose
gismos957183gismos_
gizmos1844133gizmos_
glimpse1233763glimpse
globose1035543globose
glucoses1145333glucoses
glume85120463glum__e
glumes94516813glumes_
glums84621423glum_s_
goose65925903g__oose
gramas94317203gramas_
gramme114210333gram_me
grammes123611323grammes
gramps114114273gramps_
grams85327313gram_s_
granulose1044143granulose
grease75416233gr_ease
gregos847533gregos_
gremmie1264383gremmie
grilse7399503gr_ilse
grimace1255083grimace
grime85021323grim__e
grimes94619033grimes_
grooms94512523grooms_
groove10438873gr_oove
grope84821613gr__ope
gross65421693gr__oss
grosz154814093gr__osz
grosze16457733gr__osze
grouse74315023gr_ouse
grove95219333gr__ove
grubs86312603gru_bs_
grudge9388583gru_dge
grudges10349423grudges
grue55825713gru___e
gruels73910153gruels_
grues65721963gru_es_
gruesome1144283gruesome
gruffs13337453gruffs_
grum75625083grum___
grumbled14256753grumbled
grumbler13866683grumbler
grumbles13288873grumbles
grumbly15355403grumbly
grummer12338783grummer
grummest13286363grummest
grummet12298873grummet
grump105115313grum__p
grumped13337333grumped
grumphie1642763grumphie
grumphy18443623grumphy
grumpier1334803grumpier
grumpish1643763grumpish
grumpy14498153grum_py
grunge8359583gru_nge
grunges93310403grunges
gruntle8257053gruntle
grunts75511853grunts_
grushie1135813grushie
gruyere1133123gruyere
guise64717713g_u_ise
gumbos114610873g_umbos_
gummoses1344743gummoses
gums75030943g_um_s_
gyrose105310253g_yrose
mucose10149313_mucose
osmose8108003_osmose
premise113818553premise
premorse1237553premorse
primos104514423primos_
primrose1244503primrose
promise113415843promise
promos105116423promos_
promote11313143promote
propose112714843propose
prose75835123pr__ose
pruinose1044853pruinose
purpose1137383purpose
remise84221953_remise
remorse9311713_remorse
remote84222603_remote
remove116115573_remove
repose84121413_repose
rerose63320843_rerose
ribose839893_ribose
roose56127093_r_oose
rose46148903_r__ose
rugosa734563_rugosa
rumble103718813_rumble
rumor71011323_rumo_r
rumored1046643_rumored
rumors81110403_rumors
rumour8127383_rumour
rumple103913013_rumple
rumps95922293_rumps_
rums64833473_rum_s_
ruse45938933_ru__se
spumone1154383spumone
squamose1944273squamose
sumos75720093_sumos_
surmise9311083surmise
triose64715383tr_iose
trumps104611883trumps_
urinose738483urinose
vamose1159283_vamose

Search took 7 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.406440125.6
2DLD Change Limit1340271536.50020619.5
3Display Results1531530.0463326.1
 (SQL Overall)1786911536.95225703.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.