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

265 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
rummest1127983(None) 
bummest13298621bummest
grummest13286361grummest
rummiest12299351rummiest
crummiest1545562crummiest
dimmest1249252dimmest
dumbest1238742dumbest
fumiest12312192fumiest
glummest13235562glummest
grimmest13286292grimmest
grummet12298872grumme_t
grummets13275032grummets
gummiest13269022gummiest
numbest1138792numbest
plummest14276412plummest
primmest14226692primmest
rammiest12299932rammiest
rimiest93215852rimiest
rubiest92914422rubiest
rudest74016312ru_dest
ruliest72816432ruliest
rummer104715482rumme_r
rummers113513652rummers
rummies113212792rummies_
trimmest12227022trimmest
yummiest15256722yummiest
armrest9310163armrest
augment10910203augment
auldest839893auldest
brumes106417073bru_mes_
bruskest14315903bruskest
buffest15298643buffest
bummed134211723bumme_d
bummer124014103bumme_r
bummers133712443bummers
bumpiest1437873bumpiest
busiest93716303busiest
buxomest1942183buxomest
calmest11312343calmest
chummiest1834643chummiest
comment1310317703comment
crudest104510333cru_dest
cruelest1059183cruelest
crumbiest1536253crumbiest
crummies1437643crummies_
crumpet133711063crumpe_t
crumpets14335943crumpets
cummer124414593cumme_r
cummers133713483cummers
curtest9713963curtest
cutest85820143cu_test
dampest12411043dampest
drumbeat1343973drumbeat
drumliest1235433drumliest
drummed13306323drumme_d
drummer12407503drumme_r
drummers13316163drummers
drunkest1334423drunkest
dullest8312633dullest
dummies123012133dummies_
dumpiest1338743dumpiest
dunnest83312263dunnest
durmast1037623durmast
elmiest9310743elmiest
emmet94221383_emme_t
emmets10349153_emmets
erumpent1245453erumpent
femmes135410213femmes_
firmest1239273firmest
frumpiest1634543frumpiest
fullest10313343fullest
fumes105224703fu_mes_
fumet105630223fu_me_t
fumets114311813fu_mets
funest94316863fu_nest
funfest13348083funfest
funnest102912003funnest
gamest94919923_gamest
gamiest102816223gamiest
gammiest13339323gammiest
gemmiest13227623gemmiest
gimmes113010903gimmes_
grammes123611323grammes_
grimiest11299823grimiest
grommet12268453gromme_t
grommets13234663grommets
gruffest1544593gruffest
grumes94415553gru_mes_
grummer12338783grumme_r
grumpiest1435023grumpiest
guest65225923gu__est
gumless10228273gumless
gummas114810513gummas_
gummed123811663gumme_d
gummer114615453gumme_r
gummers123712203gummers
gummose1235333gummose
hammiest152610003hammiest
homiest124116633homiest
hugest10311763hu_gest
humanest1348123humanest
humblest15288283humblest
hummed144812673humme_d
hummer133615273humme_r
hummers143813063hummers
hummus1336243hummus_
humpiest1538963humpiest
hutment1239173hutment
immesh1334113_immesh
jammiest19307203jammiest
jimpest18297553jimpest
jumpiest1936863jumpiest
justest1449893justest
kummel14266173kumme_l
kummels15234793kummels
lamest84722763_lamest
limiest93716103limiest
limpest113712313limpest
lumpiest1239253lumpiest
luniest73516993luniest
lushest103312283lushest
mammet94319253mamme_t
mammets103911113mammets
mummed104411553mumme_d
mummer93614543mumme_r
mummers103712843mummers
mummery13336663mummery
mummies103812843mummies_
mumms85513153mumm_s_
murkest133110203murkest
mutest84218053mu_test
nudest74113833nu_dest
nutmeat947953nutmeat
outmost9511213outmost
plumiest122110293plumiest
plummet13278353plumme_t
plummets14304773plummets
plummiest1544973plummiest
plumpest14236353plumpest
pummel12278043pumme_l
pummelo13284233pummelo
pummels13236543pummels
puniest92918093puniest
punkest132611693punkest
purest84021933pu_rest
quest144121323qu__est
raciest92820013raciest
raiment9315413raiment
ramees84620893ramees_
ramet75743143r_ame_t
ramets83517393r_amets
ramies84630463ramies_
ramjet15311543ramje_t
ramjets1635163ramjets
rammed113117303ramme_d
rammer103519653ramme_r
rammers113715043rammers
rammish1437563rammish
rankest112713813rankest
rarest65725483r_arest
rashest103916873rashest
rawest93615063r_awest
realest73322433realest
reddest9311953reddest
reest54938093r__eest
remeet86325473r_emeet
remeets93712413remeets
remelt85123123r_emelt
remet74843723r_eme_t
remotest103310723remotest
renest64529713r_enest
request16311023request
resmelt9411773resmelt
rest46459843r___est
retest64028453r_etest
revest94623603r_evest
rhemes115913183rhemes_
rheumiest1442863rheumiest
rhymes14419823rhymes_
richest122813683richest
rifest93114583r_ifest
rimes75634543r_imes_
rimless9369363rimless
rimmed114812303rimme_d
rimmer103516033rimme_r
rimmers113812883rimmers
ripest84317943r_ipest
roomiest102611993roomiest
ropiest93317773ropiest
rosiest73919213rosiest
roughest1238773roughest
roundest9310473roundest
roupiest102610293roupiest
rubes74928413ru_bes_
rubies84420343rubies_
rubles83921703rubles_
ruches114819583ruches_
ruddiest10278543ruddiest
rudiment1147663rudiment
rues46044483ru__es_
ruffes124112423ruffes_
rules55234253ru_les_
rumbas102512013rumbas_
rumbles114018393rumbles_
rumen74419503ru_me_n
rumens83611813ru_mens
rummage1234583rummage
rummages1344933rummages_
rummier11309563rummier
rummy124212413rumm__y
rumors81110403rumors_
rumples113313133rumples_
rumpless12256543rumpless
rumpliest1345313rumpliest
rumps95922293ru_mps_
rumpus10458893rumpus_
rums64833473ru_m_s_
runes55530223ru_nes_
runless72810423runless
runlet63821413runle_t
runlets73310773runlets
runniest82911203runniest
runtiest83014513runtiest
rupees8312573rupees_
ruses56136583ru_ses_
rushes94724363rushes_
rushiest113312923rushiest
russet6319433russe_t
russets738163russets
rust45544913ru___st
rustiest83116803rustiest
ruttiest82712663ruttiest
scummiest1535213scummiest
slimmest1235903slimmest
slummiest1335663slummiest
spumiest1238203spumiest
suavest10310623suavest
subtest9513963subtest
suggest9310863suggest
sumless92611123sumless
summas104313163summas_
summed114014043summe_d
summer104017713summe_r
summers113616503summers
summerset1347253summerset
summery14329413summery
summit10311543summ_it
summits1137983summits
sumoist9311613sumoist
surest65026763su_rest
tamest85721293_tamest
tempest1139223tempest
thrummiest1742093thrummiest
truest64816193tru__est
trumpet113810723trumpe_t
trumpets12315573trumpets
tummies113012033tummies_
unmeet83815743_unmeet
unmesh1145793_unmesh
unmet74426393_unme_t
unrest62918853_unrest
upmost1068193_upmost
utmost878483_utmost
warmest123113033warmest
yummies14359533yummies_

Search took 8 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.1401276364.3
2DLD Change Limit1340272657.00019146.7
3Display Results2652650.0932849.5
 (SQL Overall)1786912657.23324705.0
 
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.