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

349 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
stunners827792(None) 
scunners10357301scunners
shunners11317741shunners
stunner7349191stunner_
cunners93913472_cunners
gunners83111732_gunners
punners94114242_punners
runners74212452_runners
saunters82911752saunters
scanners10379702scanners
scunner9358242scunner_
shunner10358642shunner_
shunters113210752shunters
sinners74019022s_inners
skinners12347292skinners
sounders93214122sounders
spanners103710772spanners
spinners103810862spinners
spurners10288492spurners
stainers83212172stainers
standers93514302standers
stingers94012742stingers
stinkers123111132stinkers
stinters83312762stinters
stoners74817962st_oners
studiers9236622studiers
stuffers14277382stuffers
stuivers11406672stuivers
stumpers12318312stumpers
stunned8358892stunne_d
stutters83210472stutters
sunders84120062s_unders
tanners74018392_tanners
tenners74014922_tenners
tinners73717312_tinners
tonners73816402_tonners
tuners64417342_tu_ners
tunnels7328722_tunnels
turners73912892_turners
aginners954623aginners
atoners75013963at_oners
banners94018713_banners
blunders113911353blunders
blungers11469853blungers
bouncers12309353bouncers
bounders114314123bounders
branners104010923branners
bunkers133715953_bunkers
bunters94717123_bunters
burners94115673_burners
canners93822663_canners
chunnels13304563chunnels
chunters133910903chunters
churners13316893churners
clunkers14327563clunkers
conners94023113_conners
counters103320193counters
cunner83915003_cunner_
daunders10278483daunders
daunters9329853daunters
dinners83915443_dinners
dunkers123512193_dunkers
dunner73913823_dunner_
dunness8298983_dunness
fanners103914653_fanners
flunkers15347543flunkers
founders123911683founders
funders113813943_funders
funkers143712063_funkers
funnels10348173_funnels
funner93414103_funner_
ginners84314223_ginners
grinners9288043grinners
grungers10298503grungers
grunters9359043grunters
gunnels8358563_gunnels
gunner73813983_gunner_
gunnery11376373_gunnery
haunters11329543haunters
hounders123111723hounders
hungers114013303_hungers
hunkers143314333_hunkers
hunters103915733_hunters
inners63919353__inners
junkers184010863_junkers
lanners73618333_lanners
launders9358753launders
loungers9449003loungers
lungers83817103_lungers
lunkers113414613_lunkers
manners93417833_manners
maunders11348353maunders
mounters103712503mounters
mourners1036913mourners
nunnery10355303_nunnery
outrunners1042833outrunners
panners93621273_panners
penners93414183_penners
pinners93518603_pinners
planners10399943planners
plunders11329843plunders
plungers11379413plungers
plunkers14328343plunkers
pouncers12349213pouncers
pounders113113293pounders
pruners93710733pru_ners
punkers133714863_punkers
punner84918163_punner_
punnets9409263_punnets
punters93617053_punters
returners9376553returners
rounders92613703rounders
ruiners74213023_ruiners
runnels7329163_runnels
runner63814463_runner_
sanders84025943s_anders
sangers84421943s_angers
saucers93712133sau_cers
sauciers1076733sauciers
saugers83914053sau_gers
saunter72913453saunter_
scanner94411813scanner_
scorners10228493scorners
scuffers16307493scuffers
sculkers14306933sculkers
scullers103510483scullers
scummers14277783scummers
scunnered1243803scunnered
scuppers1446543scuppers
scutters103311023scutters
seiners74219273s_einers
senders83022353s_enders
sennets73712583s_ennets
shiners104015943s_hiners
shinnery14305683shinnery
shinneys14275103shinneys
shotgunners155893shotgunners
shuckers17388133shuckers
shudders13316643shudders
shunned11417843shunne_d
shunter103611733shunter_
shushers14267053shushers
shutters113611353shutters
signers84714443s_igners
singers83824703s_ingers
sinkers113618543s_inkers
sinner64320603s_inner_
sinters74024083s_inters
skankers11316483skankers
skinkers11298183skinkers
skinner11348093skinner_
skulkers11334923skulkers
slanders94014023slanders
slingers93712683slingers
slubbers12349943slubbers
sluggers10348483sluggers
slumbers123110273slumbers
slummers12358933slummers
smugness1143813smugness
sneers64016173s__neers
snubbers12326673snubbers
snubness1044373snubness
snuffers14326923snuffers
snugness934323snugness
sonders83820713s_onders
sonnets74211993s_onnets
sooners73916643s_ooners
sorners73416873s_orners
sounder83315393sounder_
soundness1036963soundness
sourness839543sourness
souters74422603sou_ters
southers114214453southers
spankers14369863spankers
spanner94312563spanner_
spawners13396493spawners
spencers12269193spencers
spenders113211743spenders
spinner93912263spinner_
spinnery13416593spinnery
spinneys13335553spinneys
spongers1137603spongers
spudders12255633spudders
spurner9269653spurner_
spurrers10338463spurrers
spurters103311703spurters
sputters104012873sputters
squanders1934443squanders
squarers17338033squarers
squinters1835523squinters
stabbers12268733stabbers
stablers103611153stablers
stackers143413563stackers
staffers14247083staffers
stagers84116673st_agers
staggers10379843staggers
stainer73614923stainer_
stalkers12369853stalkers
stammers123611523stammers
stampers124211603stampers
stances93715963stance_s
stanchers14206813stanchers
standees93310143standees
stander84316163stander_
stanes64933403st_ane_s
stanines85115673stanine_s
stannary1144613stannary
stannous846443stannous
stannums1043803stannums
staplers103111203staplers
starers74522313st_arers
starkers123712393starkers
starters83714783starters
starvers11459643starvers
staters73922343st_aters
stayers103813633st_ayers
stealers83412213stealers
steamers103410873steamers
steepers103011373steepers
steerers82511353steerers
steers63820983st__eers
stemmers12378443stemmers
stentors839753stentors
steppers12289283steppers
sterner7411913sterner_
sternness946093sternness
stickers142913033stickers
stiflers11238833stiflers
stinger84314683stinger_
stinker113313313stinker_
stinter73614513stinter_
stirrers8266943stirrers
stivers103613543st_ivers
stockers143411073stockers
stokers114515183st_okers
stompers123610043stompers
stoner65823203st_oner_
stones65130033st_one_s
stonier72013793stonier_
stoniness938343stoniness
stookers12449793stookers
stoopers103711303stoopers
stopers94217373st_opers
stoppers123910593stoppers
storers75018683st_orers
stoutness945863stoutness
stovers103713733st_overs
strafers11379913strafers
strainers9510403strainers
stranders10389943stranders
strangers104112173strangers
strayers113510143strayers
strewers11409073strewers
striders94412123striders
strikers123611293strikers
stringers104210653stringers
stripers103911593stripers
strivers113911843strivers
strokers123910913strokers
stroyers11388933stroyers
strummers1333693strummers
strutters955703strutters
stuccoers1342563stuccoers
students954683students
studier82510053studier_
studies82413863studie_s
stuffer13349793stuffer_
stuiver10447083stuiver_
stumblers1334383stumblers
stumper113610093stumper_
stunning9298463stunning
stuns54719493stu_n__s
stunted83010403stunte_d
stunts65615253stu_n_ts
stupes84116953stu_pe_s
stupors935883stu_pors
stutter72911463stutter_
stylers10359353st_ylers
subers85722643s_u_bers
subnets92512083s_ubnets
suckers133717623s_uckers
sudsers83310423s_udsers
suers55128483s_u__ers
suffers133113543s_uffers
suiters73618883s_uiters
sulkers113613343s_ulkers
summers113616503s_ummers
sunder74019833s_under_
sundews11398153s_undews
sunkets113511283s_unkets
sunless73013693s_unless
sunnahs10326593s_unnahs
sunnas63914563s_unn_as
sunned74216323s_unne_d
sunnier73412153s_unnier_
sunns55017353s_unn__s
sunsets72911573s_unsets
supers84622403s_u_pers
suppers113314703s_uppers
surfers103614133s_urfers
surgers83517483s_urgers
sutlers73116973s_utlers
swannery1433553swannery
swingers123710423swingers
swinneys14264203swinneys
swooners11336863swooners
tankers113416913_tankers
tanner63722293_tanner_
tannery10388663_tannery
taunters8259273taunters
teeners74415453_teeners
tenders83719723_tenders
tenner64117103_tenner_
tenoners858713_tenoners
tenters73921113_tenters
thinners11327763thinners
thunders1236963thunders
tinders84219173_tinders
tinkers113517143_tinkers
tinner64119963_tinner_
tinters74221113_tinters
toners64128003_t_oners
tongers84116013_tongers
tonner64819203_tonner_
tonnes65320853_tonne_s
trunnels844513trunnels
tubbers113411253_tubbers
tubers85017033_tu_bers
tuckers134014353_tuckers
tufters10298353_tufters
tuggers93711443_tuggers
tuner56022683_tu_ner_
tunes55332193_tu_ne_s
tunned74014493_tunne_d
tunnel64310633_tunne_l
tunnelers953463_tunnelers
tunnies73614263_tunnies
turner63914613_turner_
turnery10357423_turnery
tuskers113710043_tuskers
tussers74313563_tussers
tuyers94612563_tu_yers
twiners10459633_twiners
vanners103612843_vanners
vaunters11327753vaunters
winners104316913_winners
wonners104312813_wonners
youngers12336933youngers
younkers15295763younkers

Search took 7 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.420425454.8
2DLD Change Limit1461623496.28323263.1
3Display Results3493490.1402492.9
 (SQL Overall)1786913496.84326113.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.