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

456 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
spumier113790(None) 
fumier11310902_fumier
plumier113510042plumier
pumicer1335062_pumicer
pumper124415552_pumper
punier84519222_punier
saucier9810282saucier
scummer13398752scummer
scummier1445082scummier
seamier93114632seamier
slimier93212012slimier
slumber113811002slumber
slummer113711202slummer
slummier1235472slummier
soupier93111752soupier
spacier114011632spacier
spammer133410432spammer
spicier115112462spicier
spier75728032sp__ier
spikier13369982spikier
spinier93715162spinier
spirier93214072spirier
sprier84119062sp_rier
sprucier1254792sprucier
spudder11256552spudder
spume95817312spum_e_
spumed114711542spum_ed
spumes1021314882spum_es
spumiest1238212spumiest
spuming1248522spuming
spunkier14235822spunkier
spurner9269652spurner
spurrer93710222spurrer
spurrier10297692spurrier
spurter94013002spurter
sputter94014052sputter
studier82510052studier
stumper113610092stumper
stumpier1255882stumpier
summer104017712s_ummer
applier1137903applier
assumer965363assum_er
balmier113811513balmier
barmier114313043barmier
beamier113411943beamier
boomier113312183boomier
bouvier1277433bouvier
bummer124014103_bummer
bumper123714343_bumper
bumpier13359203_bumpier
burier84324653_burier
busier85219723_busier
chummier1734513chummier
clumber134011443clumber
clumpier1435583clumpier
clumsier1234733clumsier
costumier1343423costumier
courier93617893courier
crumber13339643crumber
crumbier1456363crumbier
crummier1435603crummier
cumber124016703_cumber
cummer124414593_cummer
cuppier1368323cuppier
daubier1037103daubier
doomier103610123doomier
drumlier1134523drumlier
drummer12407503drummer
dumber114414173_dumber
dumper114615213_dumper
dumpier12409653_dumpier
elmier839813_elmier
epimer10109153epim_er
espalier1036363espalier
filmier1237503filmier
flamier123112143flamier
flukier14397853flukier
flutier103011553flutier
foamier12339003foamier
frumpier1534173frumpier
fumer105918233_fum_er
gamier93617933_gamier
gammier123711193gammier
gaudier938453gaudier
gauzier1735633gauzier
gemmier12337383gemmier
germier10309543germier
gluier7310263glu_ier
glummer12417983glummer
glumpier1334873glumpier
goutier82612353goutier
grimier103210433grimier
grummer12338783grummer
grumpier1334803grumpier
gummer114615453_gummer
gummier12349473gummier
hammier143510653hammier
haulier1059943haulier
haulmier1333143haulmier
homier116416993_homier
hummer133615273_hummer
humper134115883_humper
humpier143110723_humpier
jammier18408023jammier
jumper173612373_jumper
jumpier18317943_jumpier
limier83518723_limier
loamier9349163loamier
lousier72411623lousier
lumber103817773_lumber
lumper103816653_lumper
lumpier113410143_lumpier
lunier64617603_lunier
malmier113611953malmier
mousier93712463mousier
mummer93614543_mummer
mumper123513523_mumper
number103913223_number
pacier105018683_pacier
palier85023563_palier
palmier113312173palmier
pamper124316663_pamper
panier84425503_panier
pier66035293_p__ier
pinier84024693_pinier
pipier104913983_pipier
pitier84019823_pitier
plier75221283_p_lier
plumber13339983plumber
plummer13298523plummer
plummier1434123plummier
plumper13318773plumper
pokier124914633_pokier
poutier93215323poutier
poxier153812113_poxier
premier113515633premier
prier75027763_p_rier
primer105118683_primer
pucker143817633_pucker
pudgier11377723_pudgier
puffer144610733_puffer
puffier1547973_puffier
puggier11309383_puggier
puler74826623_pu_ler
puller83820813_puller
pulper103513273_pulper
pulpier1148623_pulpier
pulser84215193_pulser
pumice1238223_pumice
pumiced1435173_pumiced
pumicers1434353_pumicers
pumices1338273_pumices
pummel12278043_pummel
pumped133915563_pumped
pumpers133113673_pumpers
punker123718823_punker
punkier133512793_punkier
punner84918153_punner
punnier93511263_punnier
punter84320023_punter
purer75127903_pu_rer
purger94717233_purger
purser85020473_purser
pursier94012753_pursier
purtier93214093_purtier
pusher114318283_pusher
pushier123611093_pushier
pussier93711993_pussier
putter83921443_putter
puttier93314503_puttier
rammier112811023rammier
rheumier1342513rheumier
rimier83916273_rimier
roomier93812243roomier
roupier9319493roupier
rubier84814743_rubier
rulier65016353_rulier
rummer104715483_rummer
rummier11309563rummier
saggier92912063saggier
sagier73717163s_agier
sallier73320423sallier
saltier74318633saltier
samiel8313333s_amiel
sandier84017843sandier
sappier113613123sappier
sarkier113413313sarkier
sassier73413233sassier
saucer84314103sau_cer
sauciers1076733sauciers
sauger74316253sau_ger
saunter72913453saunter
sauries72821623sauries
savvier1335483savvier
scalier94316913scalier
scammer133611973scammer
scamper134613163scamper
scarier94017873scarier
schmeer1475363schmeer
scimiter1236143scimiter
scuffer15328883scuffer
sculker13318323sculker
sculler99812153sculler
scummed14347913scummed
scummers14277783scummers
scunner9358243scunner
scupper1367423scupper
scurfier13267053scurfier
scurvier13255883scurvier
scutter93512173scutter
scuzzier1842713scuzzier
seamer84223613seam_er
sedgier9399053sedgier
seedier83513633seedier
seemer84418043seem_er
seemlier1035193seemlier
seepier92912013seepier
sexier13310683s_exier
shadier113111153shadier
shakier143411153shakier
shalier103116423shalier
shammer144613143shammer
shier85428943s__hier
shimmer143310873shimmer
shinier104113143shinier
showier1339103showier
shucker163710103shucker
shudder12297323shudder
shunner10358643shunner
shunter103611733shunter
shusher13288113shusher
shutter103712143shutter
silkier114411643silkier
sillier74017593sillier
siltier73413863siltier
simmer104115353s_immer
simper103616293s_imper
sirupier1034303sirupier
sissier73711363sissier
sizier1514813393s_izier
skier95119593s__kier
skimmer15327533skimmer
skimpier1634293skimpier
skulker10325683skulker
skunkier11174283skunkier
slammer113913033slammer
slatier74016813slatier
slier54827243s__lier
slimmer114211343slimmer
slimsier1085213slimsier
slubber113010763slubber
sludgier1034823sludgier
slugger93610683slugger
slumbers123110273slumbers
slumbery15296043slumbery
slumism1136513slumism
slummed12359273slummed
slummers12358933slummers
slumped123710153slumped
slushier1135983slushier
sluttier836453sluttier
smarmier1235033smarmier
smiler83916683s__miler
smiter83616413s__miter
smokier1356703smokier
smudgier1233753smudgier
smugger11327053smugger
smuttier1035213smuttier
snakier112810003snakier
snoutier8206973snoutier
snowier1038793snowier
snubber11277733snubber
snubbier1244993snubbier
snuffer13318853snuffer
snuffier14276943snuffier
snugger9318313snugger
soapier93411713soapier
soggier93410883soggier
soldier82812153soldier
somber103714003s_omber
sonsier7711743sonsier
sootier73916613sootier
soppier112711583soppier
sorrier72313733sorrier
sounder83315383sounder
sourer63620213sou_rer
souter64225923sou_ter
souther104116303souther
spacer104917793sp_acer
spader94317133sp_ader
spaller92713473spaller
spammed14348523spammed
spammers14378693spammers
spaniel948923spaniel
spanker133612353spanker
spanner94312563spanner
sparer84524963sp_arer
sparger103613083sparger
sparker133914363sparker
sparkier14298033sparkier
sparrier10329143sparrier
sparser94311483sparser
spatter94016523spatter
spavie113611383spavie_
spavies123012953spavies
spaviet123011933spaviet
spawner12347363spawner
speaker133311213speaker
spearer93913663spearer
specie10412223specie_
species11314133species
specter113111733specter
speeder103811073speeder
speedier1146623speedier
speer74623903sp__eer
speir75315363sp_ei_r
speller95415153speller
spelter94113703spelter
spencer113610973spencer
spender103713693spender
spendier1147143spendier
spewer115112153sp_ewer
spherier1337783spherier
spicer104719313sp_icer
spider94516803sp_ider
spied85427713sp__ied
spiel74623913sp__iel
spieler93111233spieler
spiers84421743sp__iers
spies76037623sp__ies
spiffier16255883spiffier
spiker124315663sp_iker
spiller92914333spiller
spinner93912263spinner
spire75828693sp__ire
spitter94015183spitter
splicer114710523splicer
splurger1143813splurger
splurgier1252343splurgier
splutter10357443splutter
spoiler93310683spoiler
sponger1038523sponger
spongier1135743spongier
spoofer12368723spoofer
spookier14175493spookier
spooler93711383spooler
spoonier10167653spoonier
sporter93616553sporter
sportier102010053sportier
spotter94514883spotter
spottier10207313spottier
spouter94213223spouter
sprayer12369043sprayer
sprucer11317683sprucer
spryer11418533sp_ryer
spudded12235903spudded
spudders12255633spudders
spue66025523spu__e_
spued84918473spu__ed
spues75025383spu__es
spuing94313363spu_ing
spumone1154383spumone
spumones1254953spumones
spumoni1173453spumoni
spumous1135853spumous
spumy124610363spum__y
spunked14307783spunked
spunkie13215303spunkie_
spunkies14227593spunkies
spur65321193spu___r
spurge93711323spurge_
spurges104111653spurges
spurned10339263spurned
spurners10288493spurners
spurred103610623spurred
spurrers10338463spurrers
spurrey12307813spurrey
spurriers11245063spurriers
spurries102311323spurries
spurted103111973spurted
spurters103311703spurters
sputters104012873sputters
sputtery13366473sputtery
squarer163410663squarer
squire155912463squ_ire
squirmier2042853squirmier
stagier83513443stagier
stammer116013343stammer
stamper113714403stamper
steamier1048303steamier
stemmer113210183stemmer
stemmier1245253stemmier
stimied10310623stimied
stimies9316563stimies
stomper114111233stomper
stonier72013793stonier
stormier1036103stormier
strummer1234783strummer
stubbier1235353stubbier
studied9268693studied
studiers9236623studiers
studies82413863studies
studlier935473studlier
stuffer13349793stuffer
stuffier14336623stuffier
stuiver10447083stuiver
stumbler1235813stumbler
stummed12348553stummed
stumped124210153stumped
stumpers12318313stumpers
stunner7349193stunner
stupider1133913stupider
sturdier9216963sturdier
stutter72911463stutter
stymie1137623stymie_
stymied1335663stymied
stymies1239213stymies
suaver93014233s_uaver
suber74924503s_u_ber
sucker124120663s_ucker
suckier133613973suckier
sudser73511283s_udser
sudsier868783sudsier
suer45334033s_u__er
suffer124314513s_uffer
suiter64121813s_uiter
sulker104015923s_ulker
sulkier113811963sulkier
summed114014043s_ummed
summers113616503s_ummers
summery14329413s_ummery
sumpter1138873s_umpter
sunder74019823s_under
sunnier73412153sunnier
super74924483s_u_per
supper104115433s_upper
suppler1148433suppler
supplier1246603supplier
surer54833103s_u_rer
surfer93515883s_urfer
surfier102613543surfier
surger74320093s_urger
surlier72915443surlier
surmiser1036763surmiser
sutler63718393s_utler
swamies123712063swamies
swamper14349313swamper
swampier1544593swampier
swimmer14297653swimmer
swimmier15174313swimmier
syrupier1343053syrupier
thumper14356953thumper
thymier1534393thymier
umber94617593__umber
wormier12278763wormier
yummier14306843yummier

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.406440125.6
2DLD Change Limit1340274566.65620136.3
3Display Results4564560.1732635.8
 (SQL Overall)1786914567.23524698.1
 
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.