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

193 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
grummet1229887(None) 
grommet12268451grommet
grummer12338781grummer
grummest13286361grummest
grummets13275031grummets
crumpet133711062crumpet
drummed13306322drummed
drummer12407502drummer
glummer12417982glummer
glummest13235562glummest
gourmet1059202gourmet
gramme114210332gramme_
grammes123611322grammes
grimmer123510092grimmer
grimmest13286292grimmest
grommets13234662grommets
grume86218162gru_me_
grumes94415552gru_mes
grummeted1552152grummeted
grumped13337332grumped
gummed123811662g_ummed
gummer114615452g_ummer
plummet13278352plummet
rummer104715482_rummer
rummest11279832_rummest
trumpet113810722trumpet
armet76739453ar__met
armlet84118193ar_mlet
brimmed14386783brimmed
brimmer13348803brimmer
brume95817983bru_me_
brumes106417073bru_mes
brunet84419293bru_net
bummed134211723_bummed
bummer124014103_bummer
bummest13298623_bummest
chummed17396443chummed
crammed143710123crammed
crammer134010963crammer
crimmer133310773crimmer
cruet74831843cru__et
crumbed14378473crumbed
crumber13339643crumber
crummie1336153crummie
crummier1435603crummier
crummies1437643crummies
crummiest1545563crummiest
crummy15365893crumm_y
crumped144311223crumped
crumpets14335943crumpets
cruset84425093cru_set
cummer124414593_cummer
drammed13378073drammed
drugget10337613drugget
drumbeat1343973drumbeat
drummers13316163drummers
emmet94221383__emmet
erumpent1245453erumpent
fumet105630223_fu_met
gammed124216163g_ammed
gammer1112318333g_ammer
gaumed104610323gau_med
gemmed12329573g_emmed
gimlet93716663g_imlet
gimme102411343g_imme_
gimmes113010903g_immes
glimmer12437713glimmer
glommed13265443glommed
glume85120463glu_me_
glumes94516813glu_mes
gourmets1144153gourmets
gramma11499803gramm_a
grammar12406893grammar
grammas12499773grammas
greet65835323gr__eet
gremmie1264383gremmie
gremmies1355993gremmies
gremmy1454473gremm_y
grime85021323gr_ime_
grimed104714093gr_imed
grimes94619033gr_imes
grimier103210433grimier
grimiest11299823grimiest
gripmen1235033gripmen
grivet103517823gr_ivet
grommeted1553163grommeted
groomed11379503groomed
groomer10399873groomer
grubbed13406433grubbed
grubber12417913grubber
grudge9388583grudge_
grudged11317163grudged
grudger10368313grudger
grudges10349423grudges
grue55825713gru__e_
gruel66014743gru__el
grueled937133grueled
grueler837023grueler
grues65721963gru__es
gruffed1544943gruffed
gruffer1475793gruffer
gruffest1544583gruffest
grum75625083gru_m__
grumble12349233grumble
grumbled14256753grumbled
grumbler13866683grumbler
grumbles13288873grumbles
grumbly15355403grumbly
grummeting1642453grummeting
grumose1035723grumose
grumous1086613grumous
grump105115313gru_m_p
grumphy18443623grumphy
grumpier1334803grumpier
grumpiest1435023grumpiest
grumps114510573gru_mps
grumpy14498153gru_mpy
grunge8359583grunge_
grunger9389783grunger
grunges93310403grunges
grunt65523543gru__nt
grunted9339283grunted
grunter83110783grunter
grutten885283grutten
guglet84018223g_uglet
gullet74924833g_ullet
gumma105313103g_umm_a
gummas114810513g_ummas
gummata1244613g_ummata
gummers123712203g_ummers
gummier12349473g_ummier
gummiest13269023g_ummiest
gummite1236133g_ummite
gummy135413653g_umm_y
gunmen9348723g_unmen
gurglet94412033gurglet
gurnet74920873g_urnet
gusset7316433g_usset
hummed144812673_hummed
hummer133615273_hummer
krimmer15376873krimmer
kummel14266173_kummel
mammet94319253_mammet
maumet103518883mau_met
mummed104411553_mummed
mummer93614543_mummer
plummer13298523plummer
plummest14276413plummest
plummets14304773plummets
premeet11615153premeet
primmed14388853primmed
primmer134310163primmer
primmest14226693primmest
pummel12278043_pummel
ramet75743143_r_amet
ramjet15311543_ramjet
rammed113117303_rammed
rammer103519653_rammer
remeet86325473_remeet
remet74843723_r_emet
rimmed114812303_rimmed
rimmer103516033_rimmer
rumen74419503_ru_men
rummers113513653_rummers
rummier11309563_rummier
rummies113212793_rummies
rummiest12299353_rummiest
rummy124212413_rumm_y
runlet63821413_runlet
russet6319433_russet
scrummed1554313scrummed
scummed14347913scummed
scummer13398753scummer
slummed12359273slummed
slummer113711203slummer
strummed1344473strummed
strummer1234783strummer
strumpet1256033strumpet
stummed12348553stummed
summed114014043_summed
summer104017713_summer
summit10311543_summit
thrummed1642843thrummed
thrummer1542933thrummer
trammed123810713trammed
trammel11357663trammel
trimmed12348933trimmed
trimmer113610833trimmer
trimmest12227023trimmest
trommel11315363trommel
trumped12439713trumped
trumpets12315573trumpets
unmet74426393__unmet

Search took 9 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.1561145455.1
2DLD Change Limit1340271938.04616657.6
3Display Results1931930.0633063.5
 (SQL Overall)1786911938.26521620.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.