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

342 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
stumpers1231831(None) 
stampers124211601stampers
stompers123610041stompers
stumper113610091stumper_
bumpers133912052_bumpers
dumpers123412662_dumpers
humpers142713522_humpers
jumpers18399842_jumpers
lumpers113514482_lumpers
mumpers133311372_mumpers
plumpers14357292plumpers
pumpers133113672_pumpers
scampers143611032scampers
scummers14277782scummers
scuppers1446542scuppers
simpers113014122s_impers
slumbers123110272slumbers
slummers12358932slummers
stammers123611522stammers
stamper113714402stamper_
steepers103011372steepers
stemmers12378442stemmers
steppers12289282steppers
stomper114111232stomper_
stoopers103711302stoopers
stopers94217372st_opers
stoppers123910592stoppers
stripers103911592stripers
strummers1333692strummers
strumpets1362892strumpets
studiers9236622studiers
stuffers14277382stuffers
stuivers11406672stuivers
stumblers1334382stumblers
stumped124210152stumpe_d
stumpier1255882stumpier_
stumps104912282stump__s
stunners8277922stunners
stupes84116952stu_pe_s
stupors935882stu_pors
stutters83210472stutters
summers113616502s_ummers
sumpters1238022s_umpters
supers84622402s_u_pers
suppers113314702s_uppers
swampers15317472swampers
tampers113516742_tampers
tempers113513012_tempers
thumpers15365712thumpers
assumers1064963assum_ers
attempers13103503attempers
bummers133712443_bummers
bumper123714343_bumper_
campers134220293_campers
champers173311623champers
chompers17369593chompers
clampers143211893clampers
clumbers143910413clumbers
costumers1374853costum_ers
costumiers1442973costumiers
crimpers14318933crimpers
crumbers14338243crumbers
crumpets14335943crumpets
cruppers14317323cruppers
cumbers134515413_cumbers
cummers133713483_cummers
cuppers133712213_cuppers
dampers123915693_dampers
distempers1544293distempers
drummers13316163drummers
dumper114615213_dumper_
dupers94615603_du_pers
fumers113613383_fum_ers
gazumpers2341423gazumpers
gulpers10299013_gulpers
gummers123712203_gummers
hampers143616953_hampers
hummers143813063_hummers
humper134115883_humper_
jumper173612373_jumper_
lampers113817333_lampers
limpers113815223_limpers
lumbers113815913_lumbers
lumpens11298263_lumpens
lumper103816653_lumper_
mummers103712843_mummers
mumper123513523_mumper_
numbers113711243_numbers
pampers133615933_pampers
paupers114311073pau_pers
plumbers14418513plumbers
plumpens14304953plumpens
plumper13318773plumper_
pulpers114612283_pulpers
pumper124415553_pumper_
retempers1345023retempers
rompers113412243_rompers
rummers113513653_rummers
samplers12299403s_amplers
sappers113518903s_appers
saucers93712133sau_cers
sauciers1076733sauciers
saugers83914053sau_gers
saunters82911753saunters
scalpers123710863scalpers
scammers14339773scammers
scamper134613163scamper_
scarpers124712513scarpers
scaupers12378173scaupers
schmeers1574833schmeers
scoopers124210193scoopers
scrapers125510533scrapers
scrimpers1554643scrimpers
scuffers16307493scuffers
sculkers14306933sculkers
scullers103510483scullers
scumless1254993scumless
scummer13398753scummer_
scunners10357303scunners
scupper1367423scupper_
scutters103311023scutters
seamers94719433seam_ers
seemers93814333seem_ers
shammers153710843shammers
shapers124016893s_hapers
sharpers133810943sharpers
shimmers15269413shimmers
shippers153012313shippers
shoppers153010763shoppers
shrimpers1633813shrimpers
shuckers17388133shuckers
shudders13316643shudders
shunners11317743shunners
shunters113210753shunters
shushers14267053shushers
shutters113611353shutters
simmers113314613s_immers
simper103616293s_imper_
sippers113117753s_ippers
skimmers16296463skimmers
skippers16318203skippers
skulkers11334923skulkers
slammers123511223slammers
slappers123710953slappers
sleepers103110113sleepers
slimmers12369633slimmers
slippers123711233slippers
slopers94213093s_lopers
slubbers12349943slubbers
sluggers10348483sluggers
slumber113811003slumber_
slumbery15296043slumbery
slummer113711203slummer_
slumped123710153slumpe_d
slumps104313583slump__s
snappers123510173snappers
snipers93311773s_nipers
snippers12299723snippers
snoopers10319843snoopers
snubbers12326673snubbers
snuffers14326923snuffers
soapers93715923s_oapers
sounders93214113sounders
souters74422603sou_ters
southers114214453southers
spammers14378693spammers
spudders12255633spudders
spumes1021314883spum_e_s
spumier1137903spumier_
spurners10288493spurners
spurrers10338463spurrers
spurters103311703spurters
sputters104012873sputters
squarers17338023squarers
stabbers12268733stabbers
stablers103611153stablers
stackers143413563stackers
staffers14247083staffers
stagers84116673st_agers
staggers10379843staggers
stainers83212173stainers
stalkers12369853stalkers
stamens93411483stam_ens
stammels12495563stammels
stammer116013343stammer_
stamped124812813stampe_d
stampede13326163stampede
stampeders15233203stampeders
stampedes14315183stampedes
stampless1334543stampless
stamps105614023stamp__s
standers93514303standers
stapes85028733st_ape_s
staplers103111203staplers
starers74522313st_arers
starkers123712393starkers
starters83714773starters
starvers11459643starvers
staters73922343st_aters
staumrels1141663staumrels
stayers103813633st_ayers
stealers83412213stealers
steamers103410873steamers
steepens10277113steepens
steeper93812773steeper_
steerers82511353steerers
steers63820983st__eers
stemless1036653stemless
stemmer113210183stemmer_
stemmery15334693stemmery
stepper113010853stepper_
steppes113110693steppe_s
stickers142913033stickers
stiflers11238833stiflers
stimes85920573stim_e_s
stimies9316563stimie_s
stingers94012743stingers
stinkers123111133stinkers
stinters83312753stinters
stipels9418953st_ipels
stipes84524053st_ipe_s
stipplers1334453stipplers
stirpes95011293stirpe_s
stirrers8266943stirrers
stivers103613543st_ivers
stockers143411073stockers
stokers114515183st_okers
stomped124110533stompe_d
stomps105612833stomp__s
stoners74817953st_oners
stookers12449793stookers
stooper93813193stooper_
stoper84320103st_oper_
stopes84525893st_ope_s
stopper113012603stopper_
storers75018683st_orers
stovers103713733st_overs
strafers11379913strafers
strappers1346743strappers
strayers113510143strayers
strewers11409063strewers
striders94412123striders
strikers123611293strikers
striper94514793striper_
stripes95320573stripe_s
strippers1355773strippers
strivers113911843strivers
strokers123910903strokers
stroppers1356713stroppers
stroyers11388923stroyers
strummer1234783strummer_
strumpet1256033strumpe_t
strutters955693strutters
stuccoers1342563stuccoers
studier82510053studier_
studies82413863studie_s
stuffer13349793stuffer_
stuiver10447083stuiver_
stumbler1235813stumbler_
stumbles1237493stumbles
stummed12348553stumme_d
stump94616463stump___
stumpage1343303stumpage
stumpages1442803stumpages
stumpiest1335863stumpiest
stumping13289083stumping
stumpy13458133stump__y
stums75320083stum___s
stunner7349193stunner_
stupas83910883stu_p_as
stupe75217753stu_pe__
stupefy1542903stu_pefy
stupids1035273stu_pids
stupor836013stu_por_
stutter72911463stutter_
stylers10359353st_ylers
stymies1239213stymie_s
subers85722643s_u_bers
suckers133717623s_uckers
sudsers83310423s_udsers
suers55128483s_u__ers
suffers133113543s_uffers
suiters73618883s_uiters
sulkers113613343s_ulkers
sumless92611123s_umless
summer104017713s_ummer_
summery14329413s_ummery
sumps95023433s_ump__s
sumpter1138873s_umpter_
sunders84120053s_unders
super74924483s_u_per_
superb104410993s_u_perb
supes75628303s_u_pe_s
supper104115433s_upper_
surfers103614133s_urfers
surgers83517483s_urgers
sutlers73116973s_utlers
swamper14349313swamper_
swappers15358083swappers
sweepers13348163sweepers
swimmers15276693swimmers
swoopers13317523swoopers
tamers84224033_tam_ers
tamper104618513_tamper_
tapers84025813_t_apers
tappers113416543_tappers
tempehs14325153_tempehs
temper103914093_temper_
tempera11329043_tempera
temperas12278233_temperas
tempters12257293_tempters
thumper14356953thumper_
timbers113111853_timbers
timers84420993_tim_ers
tippers113414353_tippers
topers85025323_t_opers
toppers113914603_toppers
trampers123210393trampers
trumpery1533613trumpery
trumpets12315573trumpets
tubbers113411253_tubbers
tubers85017033_tu_bers
tuckers134014353_tuckers
tufters10298353_tufters
tuggers93711443_tuggers
tumblers123110623_tumblers
tummlers12295703_tummlers
tumors8810613_tum_ors
tumours976753_tumours
tumped114216233_tumpe_d
tumps95420793_tump__s
tuners64417343_tu_ners
turners73912893_turners
tuskers113710043_tuskers
tussers74313563_tussers
tuyers94612563_tu_yers
umbers104215213__umbers
uppers102912293__uppers
usurpers1033743usurpers
vampers143111623_vampers
whimpers18276613whimpers
yaupers12337663yau_pers

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 Filter1786911461620.436409841.7
2DLD Change Limit1461623427.22020244.0
3Display Results3423420.1262714.3
 (SQL Overall)1786913427.78222962.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.