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

373 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
stoopers10371130(None) 
scoopers124210191scoopers
snoopers10319841snoopers
stompers123610041stompers
stookers12449791stookers
stooper93813191stooper_
stopers94217371st_opers
stoppers123910591stoppers
swoopers13317521swoopers
bloopers12397372bloopers
coopers114019482_coopers
hoopers123616482_hoopers
loopers93914032_loopers
scooper113812032scooper_
scooters103511032scooters
shooters112811582shooters
shoppers153010762shoppers
slopers94213092s_lopers
snookers12398652snookers
snooper93511532snooper_
snoozers17296942snoozers
soapers93715922s_oapers
sooners73916642s_ooners
spoofers13307322spoofers
spoolers10349362spoolers
stampers124211602stampers
steepers103011372steepers
steppers12289282steppers
stockers143411072stockers
stokers114515182st_okers
stomper114111232stomper_
stoners74817952st_oners
stooges83611482stooge_s
stooker113811732stooker_
stooped103813832stoope_d
stoops85917892stoop__s
stoper84320102st_oper_
stopes84525892st_ope_s
stopovers1443832stopovers
stopper113012602stopper_
storers75018682st_orers
stovers103713732st_overs
stripers103911592stripers
strokers123910902strokers
stroppers1356712stroppers
stroyers11388922stroyers
stumpers12318312stumpers
swooners11336862swooners
swooper12389172swooper_
toolers74416502_toolers
tooters73818772_tooters
topers85025322_t_opers
toppers113914602_toppers
troopers10289442troopers
whoopers16286262whoopers
atoners75013953at_oners
bloomers12348823bloomers
blooper11358533blooper_
boogers104514633_boogers
bookers134016613_bookers
boomers114115913_boomers
boozers183912443_boozers
boppers133911923_boppers
brooders112610243brooders
chompers17369593chompers
choosers134810873choosers
choppers174110463choppers
cooers84324563_coo_ers
cookers134619463_cookers
coolers93522493_coolers
cooper104221123_cooper_
coopery143910273_coopery
cooters94525723_cooters
copers104629843__copers
coppers133519753_coppers
crooners103911393crooners
croppers143311483croppers
doozers17419293_doozers
dopers95522483__dopers
dorpers104113173_dorpers
droppers13318603droppers
elopers95112943_elopers
estoppels1342353estoppels
estovers1136453est_overs
flooders12257833flooders
floorers11227573floorers
floppers15337463floppers
footers104618333_footers
goobers10219623_goobers
groomers11388483groomers
groovers12337123groovers
gropers104813853_gropers
groupers11358643groupers
hoofers134513323_hoofers
hookers144916513_hookers
hooper114518313_hooper_
hooters104520473_hooters
hoovers134312703_hoovers
hopers114222973__hopers
hoppers143115143_hoppers
isotopes10228073isotope_s
kotowers1534313kotowers
lookers114014073_lookers
looper83817113_looper_
looters74419163_looters
lopers84424143__lopers
loppers113014103_loppers
mooners94015343_mooners
mooters93818623_mooters
mopers104220373__mopers
moppers133412463_moppers
noosers74913923_noosers
poolers94217423_poolers
poppers103414863_poppers
proofers13118363proofers
propers113619033_propers
prospers123012263prospers
ratooners965833ratooners
rompers113412243_rompers
roofers105013903_roofers
roomers95416413_roomers
roosers74217873_roosers
rooters74522933_rooters
ropers84325903__ropers
sappers113518903s_appers
savorers1157223savorers
scalpers123710863scalpers
scampers143611033scampers
scarpers124712513scarpers
scaupers12378173scaupers
schooners1445663schooners
scoffers16286133scoffers
scolders11288993scolders
scooped124611743scoope_d
scoops105414363scoop__s
scooter93312873scooter_
scopes104719593s_cope_s
scorers94115323s_corers
scorners10228493scorners
scoters93313813s_coters
scourers10348533scourers
scouters103411323scouters
scowders14276233scowders
scowlers13257373scowlers
scrapers125510533scrapers
scuppers1446543scuppers
shapers124016893s_hapers
sharpers133810943sharpers
shippers153012313shippers
shockers17319463shockers
shoers94518333s_ho_ers
shooter103013993shooter_
shopper143312633shopper_
shoppes143411393shoppe_s
shouters113510623shouters
shovers134613003s_hovers
showers134612683s_howers
simpers113014123s_impers
sippers113117753s_ippers
skippers16318203skippers
slappers123710943slappers
sleepers103110113sleepers
slippers123711233slippers
slobbers12398523slobbers
sloggers10418783sloggers
sloops85513623sloop__s
sloper84615913s_loper_
slopes84820453s_lope_s
slotters84012403slotters
smokers13389323s_mokers
smolders11287193smolders
smoochers16184833smoochers
smoothers14206043smoothers
smothers13349933smothers
snappers123510173snappers
snipers93311773s_nipers
snippers12299723snippers
snooker113910303snooker_
snooped103711813snoope_d
snoopier10177273snoopier_
snoops84314173snoop__s
snoozer16409193snoozer_
snoozes16289783snooze_s
snorers74313803s_norers
snorters83410583snorters
soakers114114953s_oakers
soaper84517873s_oaper_
soarers74118093s_oarers
sobbers114114263s_obbers
sobers85218863s__obers
soccers1138393s_occers
solders83517773s_olders
solvers104414253s_olvers
sonders83820713s_onders
sooner64220463s_ooner_
soothers113913433soothers
sopors85215203s__opors
sorners73416873s_orners
sorters74221133s_orters
souters74422603s_outers
sowers94923443s__owers
spoilers10238633spoilers
spongers1137603spongers
spoofer12368723spoofer_
spoofery16354313spoofery
spookery17264143spookery
spooler93711383spooler_
spooneys13314583spooneys
spoors84014033spoo__rs
sporters103714063sporters
spotters104313383spotters
spouters104011163spouters
stabbers12268733stabbers
stablers103611153stablers
stackers143413563stackers
staffers14247083staffers
stagers84116673st_agers
staggers10379843staggers
stainers83212173stainers
stalkers12369853stalkers
stammers123611523stammers
stamper113714403stamper_
standers93514303standers
stapes85028733st_ape_s
staplers103111203staplers
starers74522313st_arers
starkers123712393starkers
starters83714773starters
starvers11459643starvers
staters73922343st_aters
stayers103813633st_ayers
stealers83412203stealers
steamers103410873steamers
steepens10277113steepens
steeper93812773steeper_
steerers82511353steerers
steers63820983st__eers
stemmers12378443stemmers
stepper113010853stepper_
steppes113110693steppe_s
stickers142913033stickers
stiflers11238833stiflers
stingers94012743stingers
stinkers123111133stinkers
stinters83312753stinters
stipels9418953st_ipels
stipes84524053st_ipe_s
stipplers1334453stipplers
stirpes95011293stirpe_s
stirrers8266943stirrers
stivers103613543st_ivers
stocker133713083stocker_
stodges9309083stodge_s
stogeys11486123st_ogeys
stogies8413693stogie_s
stoker104417623st_oker_
stokes104821793st_oke_s
stoles63927673st_ole_s
stollens835293stollens
stolport1046013stolport
stolports1143483stolports
stomped124110533stompe_d
stomps105612833stomp__s
stoner65823203st_oner_
stones65130033st_one_s
stonier72013793stonier_
stooge73811663stooge__
stooged94310733stooge_d
stooked124312303stooke_d
stooks105115373stoo__ks
stooled84313893stoole_d
stoolies8311083stoolies
stools65117023stoo__ls
stoop75821543stoop___
stooping113012363stooping
stope74727243st_ope__
stoped94721013st_ope_d
stopoffs1662993stopoffs
stopover1344063stopover_
stopped124512203stoppe_d
stoppered1444473stoppered
stopples1236953stopples
stops74827283st_op__s
storer64721673st_orer_
stores65533663st_ore_s
storeys10559653st_oreys
stories7324273storie_s
stoups85313273stoup__s
stoures74614163stoure_s
stours65015633st_o_urs
stoutens8255273stoutens
stouter74012053stouter_
stover94115643st_over_
stoves93818923st_ove_s
stowps115710583stowp__s
strafers11379913strafers
strappers1346743strappers
strayers113510143strayers
strewers11409063strewers
striders94412123striders
strikers123611293strikers
striper94514793striper_
stripes95320573stripe_s
strippers1355773strippers
strivers113911843strivers
strobes93813263strobe_s
stroker114113523stroker_
strokes114316323stroke_s
strollers937543strollers
strophes13310603strophes
stropper1247763stropper_
strops86220383strop__s
stroyer103510783stroyer_
studiers9236623studiers
stuffers14277383stuffers
stuivers11406673stuivers
stumper113610093stumper_
stunners8277923stunners
stupes84116953st_upe_s
stupors935883st_upors
stutters83210473stutters
stylers10359353st_ylers
supers84622403s__upers
suppers113314703s_uppers
swampers15317473swampers
swappers15358083swappers
sweepers13348163sweepers
swobbers15355593swobbers
swooner10358673swooner_
swooped13418753swoope_d
swoopier13175143swoopier_
swoops114910923swoop__s
swotters11448483swotters
tampers113516743_tampers
tapers84025813_t_apers
tappers113416543_tappers
tempers113513013_tempers
tippers113414353_tippers
tochers123413093_tochers
toilers74116263_toilers
tokers104818893_t_okers
tollers73217463_tollers
toners64128003_t_oners
tongers84116013_tongers
tonners73816403_tonners
tooler63818613_tooler_
tooter64420803_tooter_
tootlers8289503_tootlers
topees85519703_t_opees
toper75231023_t_oper_
topes76941763_t_ope_s
topper103817603_topper_
torpors939383_torpors
tossers74713503_tossers
toters65026363_t_oters
totters74618733_totters
toupees938513_toupees
tourers73512743_tourers
touters74018353_touters
towers94423673_t_owers
toyers95516333_t_oyers
trooper94210363trooper_
tropes84824353_trope_s
troupers10359443troupers
trovers103713323_trovers
twofers1364053_twofers
unstoppers1442673unstoppers
whoopees16294823whoopees
whooper15297153whooper_
whoppers18297533whoppers
wooers93712443_woo_ers
woofers133810583_woofers
woolers104214023_woolers

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.406440125.6
2DLD Change Limit1461623736.65621959.4
3Display Results3733730.1402664.3
 (SQL Overall)1786913737.20224811.3
 
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.