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

388 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
stompers12361004(None) 
stampers124211601stampers
stomper114111231stomper_
stoopers103711301stoopers
stopers94217371sto_pers
stoppers123910591stoppers
stumpers12318311stumpers
chompers17369592chompers
rompers113412242_rompers
scampers143611032scampers
scoopers124210192scoopers
shoppers153010762shoppers
simpers113014122s_impers
slopers94213092slo_pers
snoopers10319842snoopers
soapers93715922s_oapers
stammers123611522stammers
stamper113714402stamper_
steepers103011372steepers
stemmers12378442stemmers
steppers12289282steppers
stockers143411072stockers
stokers114515182sto_kers
stomped124110532stompe_d
stomps105612832stomp__s
stoners74817952sto_ners
stookers12449792stookers
stooper93813192stooper_
stoper84320102sto_per_
stopes84525892sto_pe_s
stopper113012602stopper_
storers75018682sto_rers
stovers103713732sto_vers
stripers103911592stripers
stroppers1356712stroppers
stumper113610092stumper_
swampers15317472swampers
swoopers13317522swoopers
tampers113516742_tampers
tempers113513012_tempers
topers85025322_to_pers
toppers113914602_toppers
atomies93918363atomie_s
atomisers11255453atomisers
atomizers20265553atomizers
atoners75013953ato_ners
attempers13103503attempers
bloopers12397373bloopers
bombers134512593_bombers
boomers114115913boom_ers
boppers133911923_boppers
bumpers133912053_bumpers
campers134220293_campers
champers173311623champers
chomper163810073chomper_
choppers174110463choppers
clampers143211893clampers
combers134516623_combers
comers105328083_com_ers
compeers143410013_compeers
compels133210883_compels
compere134616623_compere
comperes143217973_comperes
coopers114019483_coopers
copers104629843_co_pers
coppers133519753_coppers
crimpers14318933crimpers
croppers143311483croppers
customers1344783custom_ers
dampers123915693_dampers
distempers1544293distempers
dopers95522483_do_pers
dorpers104113173_dorpers
droppers13318603droppers
dumpers123412663_dumpers
elopers95112943elo_pers
estoppels1342353estoppels
estovers1136453esto_vers
floppers15337463floppers
gomers94116883_gom_ers
gropers104813853gro_pers
groupers11358643groupers
hampers143616953_hampers
homers114821973_hom_ers
hoopers123616483_hoopers
hopers114222973_ho_pers
hoppers143115143_hoppers
humpers142713523_humpers
isomers9310043isom_ers
jumpers18399843_jumpers
lampers113817333_lampers
limpers113815223_limpers
loopers93914033_loopers
lopers84424143_lo_pers
loppers113014103_loppers
lumpers113514483_lumpers
momsers113810843_momsers
momzers20367133_momzers
mopers104220373_mo_pers
moppers133412463_moppers
mumpers133311373_mumpers
ombers104214403__ombers
omers76923193__om_ers
ostomies10310583ostomie_s
pampers133615933_pampers
plumpers14357293plumpers
poppers103414863_poppers
prompters1537553prompters
propers113619033pro_pers
prospers123012263prospers
pumpers133113673_pumpers
retempers1345023retempers
romper104213683_romper_
roomers95416413room_ers
ropers84325903_ro_pers
samplers12299403s_amplers
sappers113518903s_appers
scalpers123710863scalpers
scammers14339773scammers
scamper134613163scamper_
scarpers124712513scarpers
scaupers12378173scaupers
schmeers1574833schmeers
scoffers16286133scoffers
scolders11288993scolders
scooper113812033scooper_
scooters103511033scooters
scopes104719593sco_pe_s
scorers94115313sco_rers
scorners10228493scorners
scoters93313813sco_ters
scourers10348533scourers
scouters103411323scouters
scowders14276223scowders
scowlers13257363scowlers
scrapers125510523scrapers
scrimpers1554633scrimpers
scummers14277783scummers
scuppers1446543scuppers
seamers94719433seam_ers
seemers93814333seem_ers
shammers153710843shammers
shapers124016893s_hapers
sharpers133810943sharpers
shimmers15269413shimmers
shippers153012313shippers
shockers17319463shockers
shoers94518333sho__ers
shooters112811583shooters
shopper143312633shopper_
shoppes143411393shoppe_s
shouters113510623shouters
shovers134613003sho_vers
showers134612683sho_wers
shrimpers1633813shrimpers
simmers113314613s_immers
simper103616293s_imper_
sippers113117753s_ippers
skimmers16296463skimmers
skippers16318203skippers
slammers123511223slammers
slappers123710943slappers
sleepers103110113sleepers
slimmers12369633slimmers
slippers123711233slippers
slobbers12398523slobbers
sloggers10418783sloggers
sloper84615913slo_per_
slopes84820453slo_pe_s
slotters84012403slotters
slumbers123110273slumbers
slummers12358933slummers
smokers13389323smo_kers
smolders11287193smolders
smothers13349933smothers
snappers123510173snappers
snipers93311773s_nipers
snippers12299723snippers
snookers12398653snookers
snooper93511533snooper_
snoozers17296943snoozers
snorers74313803sno_rers
snorters83410583snorters
soakers114114953s_oakers
soaper84517873s_oaper_
soarers74118093s_oarers
sobbers114114263s_obbers
sobers85218863s_o_bers
soccers1138393s_occers
solders83517773s_olders
solvers104414253s_olvers
somber103714003s_omber_
sonders83820713s_onders
sooners73916643s_ooners
soothers113913433soothers
sopors85215203s_o_pors
sorners73416873s_orners
sorters74221133s_orters
souters74422603s_outers
sowers94923443s_o_wers
spammers14378693spammers
spoilers10238633spoilers
spongers1137603spongers
spoofers13307323spoofers
spoolers10349363spoolers
sporters103714063sporters
spotters104313383spotters
spouters104011163spouters
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
stayers103813633st_ayers
stealers83412203stealers
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
stocker133713083stocker_
stodges9309083stodge_s
stogeys11486123sto_geys
stogies8413693stogie_s
stoker104417623sto_ker_
stokes104821793sto_ke_s
stoles63927673sto_le_s
stollens835293stollens
stolport1046013stolport
stolports1143483stolports
stomachers1783893stomachers
stomachs1544953stomachs
stomas84816323stom__as
stomates10313343stomates
stomp95616663stomp___
stomping13309763stomping
stoner65823203sto_ner_
stones65130033sto_ne_s
stonier72013793stonier_
stooges83611483stooge_s
stooker113811733stooker_
stooped103813833stoope_d
stoops85917893stoop__s
stope74727243sto_pe__
stoped94721013sto_pe_d
stopovers1443833stopovers
stopped124512203stoppe_d
stoppered1444473stoppered
stopples1236953stopples
stops74827283sto_p__s
storer64721673sto_rer_
stores65533663sto_re_s
storeys10559653sto_reys
stories7324273storie_s
stormier1036103stormier_
stoups85313273stoup__s
stoures74614163stoure_s
stours65015633sto__urs
stoutens8255273stoutens
stouter74012053stouter_
stover94115643sto_ver_
stoves93818923sto_ve_s
stowps115710583stowp__s
strafers11379913strafers
strappers1346743strappers
strayers113510143strayers
strewers11409053strewers
striders94412123striders
strikers123611293strikers
striper94514793striper_
stripes95320573stripe_s
strippers1355773strippers
strivers113911843strivers
strokers123910903strokers
strollers937543strollers
stropper1247763stropper_
stroyers11388923stroyers
strummers1333693strummers
strumpets1362893strumpets
studiers9236623studiers
stuffers14277383stuffers
stuivers11406673stuivers
stumblers1334383stumblers
stumped124210153stumpe_d
stumpier1255883stumpier_
stumps104912283stump__s
stunners8277923stunners
stupes84116953st_upe_s
stupors935883st_upors
stutters83210473stutters
stylers10359353st_ylers
stymies1239213stymie_s
summers113616503s_ummers
sumpters1238023s_umpters
supers84622403s__upers
suppers113314703s_uppers
swamper14349313swamper_
swappers15358083swappers
sweepers13348163sweepers
swimmers15276693swimmers
swobbers15355593swobbers
swooners11336863swooners
swooper12389173swooper_
swotters11448483swotters
tamers84224033_tam_ers
tamper104618513_tamper_
tapers84025813_t_apers
tappers113416543_tappers
tempehs14325153_tempehs
temper103914093_temper_
tempera11329043_tempera
temperas12278233_temperas
tempters12257293_tempters
thumpers15365713thumpers
timbers113111853_timbers
timers84420993_tim_ers
tippers113414353_tippers
tochers123413093_tochers
toilers74116263_toilers
tokers104818893_to_kers
tollers73217463_tollers
tomes76037383_tom_e_s
toners64128003_to_ners
tongers84116013_tongers
tonners73816403_tonners
toolers74416503_toolers
tooters73818773_tooters
topees85519703_to_pees
toper75231023_to_per_
topes76941763_to_pe_s
topper103817603_topper_
torpors939383_torpors
tossers74713503_tossers
toters65026363_to_ters
totters74618733_totters
toupees938513_toupees
tourers73512743_tourers
touters74018353_touters
towers94423673_to_wers
toyers95516333_to_yers
trampers123210393trampers
trompes114111623trompe_s
troopers10289443troopers
troupers10359443troupers
unstoppers1442673unstoppers
vampers143111623_vampers
vomers115614943_vom_ers
whimpers18276613whimpers
whoopers16286263whoopers
whoppers18297533whoppers

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.423422437.4
2DLD Change Limit1461623886.98320931.1
3Display Results3883880.1562487.2
 (SQL Overall)1786913887.56223630.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.