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

419 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
rummier1130956(None) 
crummier1435601crummier
gummier12349471gummier
rammier112811021rammier
rummer104715481rumm_er
rummies113212791rummies
yummier14306841yummier
bummer124014102bumm_er
bumpier13359202bumpier
chummier1734512chummier
crumbier1456362crumbier
crummie1336152crummie_
crummies1437642crummies
cummer124414592cumm_er
drumlier1134522drumlier
drummer12407502drumm_er
dummied13346722dummied
dummies123012132dummies
dumpier12409652dumpier
frumpier1534172frumpier
fumier11310902fu_mier
gammier123711192gammier
gemmier12337382gemmier
grummer12338782grumm_er
grumpier1334802grumpier
gummer114615452gumm_er
hammier143510652hammier
hummer133615272humm_er
humpier143110722humpier
jammier18408022jammier
jumpier18317942jumpier
lumpier113410142lumpier
mummer93614542mumm_er
mummied11327102mummied
mummies103812842mummies
plummier1434122plummier
rammer103519652ramm_er
rimier83916272r_imier
rimmer103516032rimm_er
roomier93812242roomier
rubier84814742ru_bier
ruddier9338522ruddier
rulier65016352ru_lier
rumbler113514112rumbler
rummager1343592rummager
rummers113513652rumm_ers
rummiest12299352rummiest
rumplier1235302rumplier
runnier74010112runnier
runtier73512852runtier
rushier103411972rushier
rustier74416362rustier
ruttier73412282ruttier
scummier1445082scummier
slummier1235472slummier
summer104017712summ_er
thrummier1641792thrummier
tummies113012032tummies
tummler11266612tummler
yummies14359532yummies
balmier113811513balmier
barmier114313043barmier
beamier113411943beamier
boomier113312183boomier
brimmer13348803brimm_er
broomier1236873broomier
brumbies1436533brumbies
brushier13306973brushier
buffier1568403buffier
buggier113611343buggier
bulgier103911213bulgier
bulkier134111513bulkier
bullier94116433bullier
bumbler134013233bumbler
bummed134211723bumm_ed
bummers133712443bumm_ers
bumming143410783bumming
bumper123714343bu_mper
burier84324653bu_rier
burlier93514413burlier
burrier93613553burrier
bushier123712813bushier
busier85219723bu_sier
bustier93916153bustier
cammie124615293cammie_
cammies134016483cammies
campier133313273campier
clammier1435843clammier
clumpier1435583clumpier
clumsier1234733clumsier
comfier1439163comfier
commie124215523commie_
commies133718453commies
crammer134010963cramm_er
crampier14288903crampier
creamier12319063creamier
crimmer133310773crimm_er
crimpier14287323crimpier
cruddier1244153cruddier
crumber13339643cru_mber
crumblier1543873crumblier
crummiest1545563crummiest
crumplier1543783crumplier
crustier10259533crustier
cumber124016703cu_mber
cummers133713483cumm_ers
cummin1288783cummi_n
cummins1358963cummins
cuppier1368323cuppier
curdier103312623curdier
curlier93314183curlier
currier93316703currier
curvier123110663curvier
cushier123610833cushier
dammer114317933damm_er
dimmer114112613dimm_er
doomier103610123doomier
dreamier11287293dreamier
druggier11134833druggier
drumfire1442543drumfire
drummed13306323drumm_ed
drummers13316163drumm_ers
drumming14265783drumming
duckier143911793duckier
dumber114414173du_mber
dumper114615213du_mper
dungier9368583dungier
duskier12409433duskier
dustier83814133dustier
elmier839813_elmier
emmer94314463_emm_er
filmier1237503filmier
flamier123112143flamier
foamier12339003foamier
fruitier1136593fruitier
fubsier12367763fubsier
fuggier12348963fuggier
fumbler143610813fumbler
fumer105918233fu_m_er
funkier14349983funkier
funnier103210173funnier
furrier103513663furrier
furzier19318103furzier
fussier103610673fussier
fustier104213933fustier
fuzzier18256523fuzzier
gambier124711973gambier
gamier93617933_gamier
gammer1112318333gamm_er
germier10309543germier
gimmie11298183gimmie_
gimmies123010113gimmies
gimpier12247943gimpier
glummer12417983glumm_er
glumpier1334873glumpier
gremmie1264383gremmie_
gremmies1355993gremmies
grimier103210433grimier
grimmer123510093grimm_er
grubbier13344753grubbier
gruffier1544703gruffier
grumbler13866683grumbler
grummet12298873grumm_et
grungier1034983grungier
gulfier1137793gulfier
gulpier1046953gulpier
gummed123811663gumm_ed
gummers123712203gumm_ers
gummiest13269023gummiest
gumming133810193gumming
gummite1236133gummite
gummites1346173gummites
gunkier12369553gunkier
gushier113110073gushier
gustier83813863gustier
gutsier8389823gutsier
guttier83911103guttier
hammer138120033hamm_er
haulmier1333143haulmier
hemmer134112643hemm_er
hempier14319003hempier
homier116416993_homier
huffier1637493huffier
hulkier14328973hulkier
humaner12257663humaner
humbler143411943humbler
hummed144812673humm_ed
hummers143813063humm_ers
humming153310673humming
humper134115883hu_mper
hunkier144512143hunkier
hurrier103412943hurrier
huskier14369763huskier
immies102412443_immies
jammer174014133jamm_er
jammies183611293jammies
jemmied19294483jemmied
jemmies18318333jemmies
jimmie17376473jimmie_
jimmied19275033jimmied
jimmies18328783jimmies
juicier1635463juicier
jumbler183910273jumbler
jumper173612373ju_mper
junkier18339493junkier
krimmer15376873krimm_er
kummel14266173kumm_el
lambier113611643lambier
limbier11349113limbier
limier83518723_limier
limmer104314793limm_er
loamier9349163loamier
luckier133811533luckier
lumber103817773lu_mber
lumper103816653lu_mper
lunier64617603lu_nier
lustier73813503lustier
luthier1038233luthier
malmier113611953malmier
mammer94218863mamm_er
mammie94313783mammie_
mammies104314763mammies
mimer94825763__mimer
mommies103912273mommies
muckier153411483muckier
muddier114110023muddier
muggier11288943muggier
mumbler133510913mumbler
mummed104411553mumm_ed
mummers103712843mumm_ers
mummery13336663mumm_ery
mummify1643333mummify
mumming114010023mumming
mumper123513523mu_mper
murkier133110273murkier
mushier123813593mushier
muskier134312733muskier
mussier93314363mussier
mustier94017963mustier
muzzier17326553muzzier
nubbier11308133nubbier
number103913223nu_mber
nutsier7329253nutsier
nuttier73112023nuttier
outlier72216143outlier
palmier113312173palmier
plumier113510043plumier
plummer13298523plumm_er
pommie123710503pommie_
pommies133712843pommies
premier113515633premier
primmer134310163primm_er
pudgier11377723pudgier
puffier1547973puffier
puggier11309383puggier
pulpier1148623pulpier
pumicer1335063pumicer
pummel12278043pumm_el
pumper124415553pu_mper
punier84519223pu_nier
punkier133512793punkier
punnier93511263punnier
pursier94012753pursier
purtier93214093purtier
pushier123611093pushier
pussier93711993pussier
puttier93314503puttier
quakier20239203quakier
qualmier1934563qualmier
querier16310013querier
racier85120973r_acier
rainier71614263rainier
rallier73816273rallier
rambler113313263rambler
ramie75027823r_amie_
ramies84630463r_amies
rammed113117303ramm_ed
rammers113715043ramm_ers
rammiest12299933rammiest
ramming123115063ramming
rammish1437563rammish
randier83618473randier
rangier83714353rangier
rapier84019993r_apier
raspier93110643raspier
rattier74015593rattier
readier83117423readier
reamer84325213ream_er
recamier1237603recamier
reedier83815303reedier
reefier102912553reefier
reekier113111123reekier
reifier103414523reifier
relier65826183r_elier
remaker133813173remaker
remember1434623remember
remoter94815973remoter
remover124612273remover
rentier73618223rentier
replier94214973replier
rheumier1342513rheumier
rhymer14387083rhym_er
ribbier1137593ribbier
ribier84414233r_ibier
ridgier937883ridgier
rimer75429243r_im_er
rimfire1243793rimfire
rimmed114812303rimm_ed
rimmers113812883rimm_ers
rimming123411073rimming
riskier1138423riskier
ritzier16297203ritzier
roamer84715163roam_er
rockier134911883rockier
roilier7311523roilier
romper104213683r_omper
rookier114012383rookier
roomer84718633room_er
roomie83013873roomie_
roomies93017243roomies
rootier74915393rootier
ropier84118803r_opier
rosier64221263r_osier
roupier9319493roupier
rowdier11348593rowdier
rubber104715793ru_bber
rubbies114114113rubbies
rubblier1244913rubblier
rubied94312413ru_bied
rubies84420343ru_bies
rudder83812803ru_dder
ruder65320543ru__der
ruer46127563ru___er
ruffler13369723ruffler
rufflier1434013rufflier
rugbies10339353rugbies
rugger84414513ru_gger
ruiner64013643ru_iner
ruler54923343ru__ler
rumbaed12287493rumbaed
rumble103718813rumble_
rumbled124514593rumbled
rumblers123610743rumblers
rumbles114018393rumbles
rumen74419503ru_m_en
rumina83412483ru_mina
rummage1234583rummage
rummaged1443273rummaged
rummagers1443033rummagers
rummages1344933rummages
rummest11279833rummest
rummy124212413rumm__y
rumor71011323ru_m_or
rumored1046643rumored
rumour8127383ru_mour
rumple103913013rumple_
rumpled123810013rumpled
rumples113313133rumples
runner63814463ru_nner
runover1034663runover
rusher94019653ru_sher
rustler73512343rustler
scummer13398753scumm_er
seamier93114633seamier
simmer104115353simm_er
slimier93212013slimier
slummer113711203slumm_er
spumier1137903spumier
stemmier1245253stemmier
strummer1234783strumm_er
stumpier1255883stumpier
suckier133613973suckier
sudsier868783sudsier
sulkier113811963sulkier
summae103911013summae_
summed114014043summ_ed
summerier1346423summerier
summers113616503summ_ers
summery14329413summ_ery
summing122912383summing
summit10311543summi_t
summited13246413summited
summiteer1343003summiteer
summitry1543323summitry
summits1137983summits
summoner1245533summoner
sumpter1138873sumpter
sunnier73412153sunnier
surfier102613543surfier
surlier72915443surlier
surmiser1036763surmiser
swimmier15174313swimmier
tammie104212693tammie_
tammies113814683tammies
thrummer1542933thrumm_er
thymier1534393thymier
tommies113812983tommies
trampier12318243trampier
trimmer113610833trimm_er
trustier8268683trustier
tubbier11237743tubbier
tuftier1096603tuftier
tumbler113412823tumbler
tummlers12295703tummlers
turfier10249793turfier
uglier748953_uglier
umber94617593_u_mber
umpire1047893_umpire
unmiter9310393_unmiter
vampier14308233vampier
vuggier12296813vuggier
wimpier14248053wimpier
wombier1436543wombier
wormier12278763wormier
wussier10408083wussier
yammer133713183yamm_er
yuckier16358533yuckier
yukkier13263893yukkier
yummiest15256723yummiest

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.1561145455.1
2DLD Change Limit1340274196.65620136.3
3Display Results4194190.1402992.9
 (SQL Overall)1786914196.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.