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

389 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
sumpter113887(None) 
sumpters1238021sumpters
bumper123714342bump_er
bumpier13359202bumpier
dumper114615212dump_er
dumpier12409652dumpier
dumpster1344052dumpster
humper134115882hump_er
humpier143110722humpier
jumper173612372jump_er
jumpier18317942jumpier
lumper103816652lump_er
lumpier113410142lumpier
mumper123513522mump_er
pumper124415552pump_er
sampler113212012sampler
scepter1138352scepter
simper103616292simp_er
simpler112910862simpler
smiter83616412s_miter
stumper113610092stump_er
stumpier1255882stumpier
suiter64121812su_iter
summer104017712sum_mer
super74924482su_p_er
supper104115432su_pper
suppler1148432suppler
tempter11358212tempter
adapter1036173adapter
adepter1036113adepter
adopter1036753adopter
ammeter1148393ammeter
ampler104313303_ampler
apter76120203__apter
bumbler134013233bumbler
bummer124014103bum_mer
bumped134414003bump_ed
bumpers133912053bump_ers
bunter85020383bu_nter
burster9310293burster
buster84726493bu_ster
butter84724233bu_tter
camper124722213camp_er
campier133313273campier
chapter144213853chapter
clumpier1435583clumpier
compeer133811553compeer
compted143813523compted
computer144511503computer
copter109822013_copter
cumber124016703cum_ber
cummer124414593cum_mer
cupper124313863cu_pper
cuppier1368323cuppier
curter85320073cu_rter
cuter74728223cu__ter
cutter84520993cu_tter
damper114117753damp_er
dempster1355773dempster
dimeter10411893dimeter
diopter1038473diopter
dumber114414173dum_ber
dumped123814493dump_ed
dumpers123412663dump_ers
dumpsters1453743dumpsters
duper85519003du_p_er
duster74919723du_ster
emoter85415193_emoter
emptier1187603_emptier
frumpier1534173frumpier
fumbler143610813fumbler
fumer105918233fum__er
fumier11310903fum_ier
gimpier12247933gimpier
glumpier1334873glumpier
grumpier1334803grumpier
gulper93410213gulp_er
gulpier1046953gulpier
gummer114615453gum_mer
gummier12349473gummier
gutter73817703gu_tter
hamper134518653hamp_er
hamster12810423hamster
hemipter1545583hemipter
hempier14319003hempier
humaner12257663humaner
humate113214443humate_
humates122813193humates
humbler143411943humbler
hummer133615273hum_mer
humped144015243hump_ed
humpers142713523hump_ers
humphed1835423humphed
hunter94817773hu_nter
hurter93915853hu_rter
imputer1136533_imputer
jimper17389863jimp_er
jumbler183910273jumbler
jumped183511553jump_ed
jumpers18399843jump_ers
juster134617013ju_ster
lamster9109913lamster
limiter92710853limiter
limper104117853limp_er
lumber103817773lum_ber
lumped114216963lump_ed
lumpen104010663lump_en
lumpers113514483lump_ers
luster64023673lu_ster
mater74438863__mater
meter75130323__meter
miter75734793__miter
mumbler133510913mumbler
mummer93614543mum_mer
mumped133813163mump_ed
mumpers133311363mump_ers
munster93710523munster
muster84724523mu_ster
muter74525543__muter
mutter84418883mu_tter
number103913223num_ber
nutter63918053nu_tter
ouster64223733ou_ster
outer55633303ou__ter
pamper124316663pamp_er
plumper13318773plump_er
prompter1437983prompter
pulper103513273pulp_er
pulpier1148623pulpier
pumicer1335063pumicer
pumped133915563pump_ed
pumpers133113673pump_ers
punster92911103punster
punter84320023pu_nter
purpler11289263purpler
putter83921443pu_tter
quarter163211853quarter
quester161410023quester
quieter162810333quieter
quilter16279803quilter
quipper2095813quipper
quipster1933933quipster
quitter162910753quitter
quoter153510093qu_oter
remoter94815973remoter
romper104213683romp_er
rumbler113514113rumbler
rummer104715483rum_mer
rummier11309563rummier
rumple103913013rumple_
rumpled123810013rumpled
rumples113313133rumples
rumplier1235303rumplier
salter64325083s_alter
saluter73512453saluter
samite83020603samite_
samites93118713samites
sample104215013sample_
sampled123410783sampled
samplers12299403samplers
samples112815453samples
sapper103822353s_apper
sappier113613113sappier
saunter72913453saunter
scamper134613163scamp_er
scamster1235303scamster
scanter94215183scanter
scatter93815173scatter
scepters1237783scepters
sceptre1135043sceptre
scimiter1236143scimiter
scooter93312863scooter
scoter83815473s_coter
scouter93313323scouter
scripter12137773scripter
sculpted1354883sculpted
sculptor1243843sculptor
scummer13398753scum_mer
scummier1445083scummier
scupper1367423scupper
scutter93512173scutter
seamster1037143seamster
seater64534153s_eater
sedater83713623sedater
seepier92912013seepier
semester1038903semester
semple103212753semple_
sempre102710093sempre_
septet8921133s_eptet
setter64023723s_etter
shaper114119933shap_er
shatter103615693shatter
sheeter103814903sheeter
shelter103214953shelter
shifter132911073shifter
shipper143514033shipper
shooter103013973shooter
shopper143312623shopper
shorter103515493shorter
shouter103213073shouter
shunter103611723shunter
shutter103712133shutter
shyster13116553shyster
sifter94516233s_ifter
sighter113412103sighter
simitar936733simitar
simmer104115353sim_mer
simperer1237173simperer
simpers113014113simp_ers
simple104315173simple_
simples113014943simples
simplex18256393simplex
sinter63625923s_inter
sipper103920983s_ipper
sister64421583s_ister
sitter63323383s_itter
skater105015483s_kater
skeeter113410413skeeter
skelter113610003skelter
skimpier1634293skimpier
skipper15339563skipper
skirter11338483skirter
skitter113810393skitter
slapper113512463slapper
slater64429183s_later
slipper113712973slipper
slitter73615873slitter
sloper84615913slop_er
slotter73314443slotter
slumber113811003slum_ber
slummer113711203slum_mer
slummier1235473slummier
slumped123710153slump_ed
smarter94113133smarter
smatter93613333smatter
smelter93311913smelter
smiler83916683s_miler
smite75224863s_mite_
smiters93414363s_miters
smites83921923s_mites
smoker124311693s_moker
smote75820273s_mote_
smother123510203s_mother
smugger11327053smugger
smutted1037463smutted
smuttier1035213smuttier
snapper113512073snapper
snifter10349623snifter
sniper84413643snip_er
snipper113911323snipper
snorter74412653snorter
soaper84517873soap_er
soapier93411713soapier
softer94015313s_ofter
somber103713993som_ber
somite84519373somite_
somites94219113somites
soppier112711583soppier
sorter64425083s_orter
soupier93111753soupier
souter64225923s_outer
spatter94016523spatter
specter113111733specter
speer74623903s__peer
spelter94113703spelter
spier75728033s__pier
spitter94015183spitter
sporter93616553sporter
spotter94514873spotter
spouter94213223spouter
spumier1137903spum_ier
spurter94013003spurter
sputter94014053sputter
squatter1735913squatter
squinter1747353squinter
squirter1746513squirter
stamper113714393stamp_er
stapler93913623stapler
starter73817873starter
stater64427553s_tater
stepper113010853stepper
stinter73614513stinter
stomper114111223stomp_er
stoper84320093stop_er
stopper113012593stopper
stouter74012053stouter
stumbler1235813stumbler
stumped124210153stump_ed
stumpers12318313stump_ers
stutter72911463stutter
suaver93014233su_aver
subduer10107033subduer
suber74924503su__ber
subitem1138543subitem
submitter1345263submitter
subpar1048663subp_ar
subtler92910843subtler
sucker124120663su_cker
suckier133613973suckier
suckler133413093suckler
sudser73511283su_dser
sudsier868773sudsier
suer45334033su___er
suffer124314513su_ffer
sugarer837323sugarer
suite54829563su_ite_
suited74019423su_ited
suiters73618873su_iters
suites63727403su_ites
suitor63311053su_itor
sulker104015923su_lker
sulkier113811963sulkier
sulphur12123873sulphur
summae103911013summae_
summate113611663summate_
summated13298833summated
summates122610483summates
summed114014043sum_med
summers113616503sum_mers
summery14329413sum_mery
summited13246393summited
summiteer1342993summiteer
summoner1245533summoner
sump86331533sump___
sumps95023433sump__s
sumptuary1651693sumptuary
sumpweed1643723sumpweed
sunder74019823su_nder
sunnier73412153sunnier
supe65932763su_p_e_
superb104410993su_p_erb
supers84622403su_p_ers
supes75628303su_p_es
supped114415703su_pped
suppers113314693su_ppers
supple10410203supple_
suppled1248463suppled
supples11511283supples
supplier1246603supplier
supporter1344513supporter
supposer1245593supposer
surer54833093su__rer
surfer93515883su_rfer
surfier102613543surfier
surger74320093su_rger
surlier72915443surlier
surmiser1036763surmiser
suspire937803suspire
sutler63718393su_tler
suttee63721543su_ttee
svelter10359673svelter
swamper14349313swamp_er
swampier1544593swampier
swapper14359703swapper
swatter104113323swatter
sweater103712723sweater
sweeter103212003sweeter
swelter103711173swelter
swifter13318053swifter
swotter10399463swotter
symptom1643973symptom
sypher14317083s_ypher
tamper104618513tamp_er
temper103914093temp_er
tempted12317283tempted
tempters12257293tempters
thumper14356953thump_er
trumpeter1343153trumpeter
tufter9319933tu_fter
tumbler113412823tumbler
tummler11266613tummler
tumped114216233tump_ed
ulster63712103_ulster
umber94617583_um_ber
umped104717273_ump_ed
umpire1047883_umpire
umpteen1143843_umpteen
uniter64619143_uniter
unmiter9310393unmiter
upper93714263_u_pper
uptear896783_u_ptear
ureter6313203_ureter
usurper934353usurp_er
utter54218763_u_tter
vamper134212653vamp_er
vampier14308233vampier
vomiter1237953vomiter
wimpier14248043wimpier
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.186960704.3
2DLD Change Limit1340273897.03319056.9
3Display Results3893890.1402778.6
 (SQL Overall)1786913897.35924282.0
 
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.