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 “spawners” 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
spawners1339649(None) 
pawners124311071_pawners
spanners103710771spanners
spawner12347361spawner_
fawners13388492_fawners
panners93621272_panners
pawers114818782_paw_ers
pawnees12298172_pawnees
pawner114212922_pawner_
pawnors12297202_pawnors
prawners1346002prawners
sawers94620162s_aw_ers
sawneys13274642s_awneys
sawyers13317532s_awyers
scanners10379702scanners
spacers113813872spa_cers
spaders104214472spa_ders
spallers102910732spallers
spammers14378692spammers
spankers14369862spankers
spanner94312562spanner_
sparers94519612spa_rers
spargers11389732spargers
sparkers144111312sparkers
spatters103914702spatters
spawned13316802spawne_d
spawns11577922spawn__s
spewers124210662spew_ers
spinners103810862spinners
sprawlers1433902sprawlers
spurners10288492spurners
stainers83212172stainers
yawners13367182_yawners
banners94018713_banners
bawlers124412733_bawlers
branners104010923branners
brawlers13408643brawlers
caners84629203_ca_ners
canners93822663_canners
chawers154412053chaw_ers
clawers123910973claw_ers
crawlers13309013crawlers
crowners133710753crowners
damners104112113_damners
darners83815773_darners
downers113912773_downers
drainers92811253drainers
drawers113610073draw_ers
drawlers12307313drawlers
drowners12428273drowners
earners74016453_earners
espaliers1144123espaliers
fanners103914653_fanners
fawner125910463_fawner_
frowners14377933frowners
gainers84214593_gainers
garners83815983_garners
gawkers15347453_gawkers
gawpers13448313_gawpers
gnawers11356393gnaw_ers
grainers93012073grainers
hawkers174210333_hawkers
hawsers13409483_hawsers
japanners1842813japanners
lanners73618333_lanners
lawyers13377153_lawyers
leaners73718173lea_ners
learners8398153learners
loaners73913623loa_ners
manners93417833_manners
meaners94415243mea_ners
moaners92813553moa_ners
openers9339493op_eners
owners94210703__owners
pacers105124543_pa_cers
packers153818893_packers
padders113312873_padders
pagers94423253_pa_gers
painters103013023_painters
palmers113513623_palmers
palters94021683_palters
pampers133615933_pampers
panders103423733_panders
panels84716523_pa_nels
panes76148693_pa_ne_s
paniers94717333_paniers
panner84224763_panner_
pannes85522853_panne_s
panniers10488853_panniers
panzers184012013_panzers
papers105125323_pa_pers
pardners11269193_pardners
parers85530743_pa_rers
parkers133816873_parkers
parsers94118153_parsers
partners102711133_partners
passers94717753_passers
pasters94531733_pasters
paters84935833_pa_ters
patness92912283_patness
patters94825193_patters
patzers184210573_patzers
paupers114311073_paupers
pausers94113223_pausers
pavers115021823_pa_vers
pawer104422973_paw_er_
pawned124513283_pawne_d
pawnee113115403_pawne_e
pawnor11357243_pawnor_
pawns108818133_pawn__s
payers114621823_pa_yers
penners93414183_penners
pewters124113353_pewters
pinners93518603_pinners
planers94517943_planers
planners10399933planners
powders134111553_powders
powers113822323_pow_ers
powters124015663_powters
prawner1246803prawner_
pruners93710723_pruners
psalters10227713psalters
punners94114233_punners
rawness1038153_rawness
sabers85224733s_a_bers
sackers133820223s_ackers
sadness8310613s_adness
saggers94017083s_aggers
sailers73822323s_ailers
sakers104125433s_a_kers
salters73622253s_alters
salvers103916003s_alvers
sanders84025943s_anders
saner54334323s_a_ner_
sanes55649073s_a_ne_s
sangers84421943s_angers
sappers113518903s_appers
saucers93712133s_aucers
saugers83914053s_augers
saunters82911753s_aunters
savers93825923s_a_vers
sawer85026213s_aw_er_
sawney12387603s_awne_y
sawyer12438043s_awyer_
sayers94221593s_a_yers
scalers93817263sca_lers
scalpers123710863scalpers
scammers14339773scammers
scampers143611033scampers
scanner94411813scanner_
scarers94618513sca_rers
scarfers13408463scarfers
scarpers124712513scarpers
scatters103612753scatters
scaupers12378173scaupers
scorners10228493scorners
scowders14276233scowders
scowlers13257373scowlers
scrawlers1434753scrawlers
scunners10357303scunners
sealers74323553sea_lers
seamers94719433sea_mers
seasoners946263seasoners
seaters74028943sea_ters
seawares1139333seawares
seawaters1235713seawaters
seaweeds12104453seaweeds
seiners74219273s_einers
sewers94719723s_ew_ers
shaders115915553sha_ders
shakers144015563sha_kers
shammers153710843shammers
shapers124016893sha_pers
sharers104720623sha_rers
sharkers154011053sharkers
sharpers133810943sharpers
shatters113313913shatters
shavers134115093sha_vers
shewers134312053shew_ers
shiners104015943s_hiners
shipowners1842123shipowners
showers134612683show_ers
shunners11317743shunners
signers84714443s_igners
sinners74019023s_inners
skankers11316483skankers
skaters113512963ska_ters
skewers14498383skew_ers
skewness1533763skewness
skinners12347293skinners
slabbers123610123slabbers
slackers143812743slackers
slakers114115753sla_kers
slammers123511223slammers
slanders94014013slanders
slappers123710943slappers
slashers113313613slashers
slaters73123733sla_ters
slathers113914783slathers
slavers103716503sla_vers
slayers104513323sla_yers
slowness1135013slowness
smackers16318713smackers
smashers13339593smashers
smatters104011713smatters
snackers143010223snackers
snappers123510173snappers
snarers74216663sna_rers
snarlers8298753snarlers
soakers114114953soa_kers
soapers93715923soa_pers
soarers74118093soa_rers
sooners73916643s_ooners
sorners73416873s_orners
sowers94923443s_ow_ers
spacer104917793spa_cer_
spaces104722633spa_ce_s
spacier114011633spacier_
spaciness1337083spaciness
spader94317133spa_der_
spades94222583spa_de_s
spadones1137253spadone_s
spaes76029973spa__e_s
spahees1238263spa_hees
spales84728103spa_le_s
spaller92713473spaller_
spammer133410433spammer_
spancels1245273spancels
spaniels1045963spaniels
spanker133612353spanker_
spanks124514123spa_n_ks
spanless10247363spanless
spanned104111223spanne_d
spans74528733spa_n__s
spanworm1544203spanworm
spanworms1643743spanworms
spareness1139863spareness
sparer84524963spa_rer_
spares84834553spa_re_s
sparger103613083sparger_
sparges104016343sparge_s
sparker133914363sparker_
sparklers15315643sparklers
spars75431543spa___rs
sparser94311483sparser_
spates85028173spa_te_s
spathes125116533spathe_s
spatter94016523spatter_
spavies123012943spavie_s
spawn107811713spawn___
spawning14296913spawning
spazzes1735263spazze_s
speakers14299453speakers
spearers103711143spearers
specters122811063specters
speeders11339313speeders
speers85019953sp__eers
spellers102812753spellers
spelters103912243spelters
spencers12269193spencers
spenders113211743spenders
spewer115112153spew_er_
sphenes123013163sphene_s
spicers113815553sp_icers
spiders103914413sp_iders
spielers10319653spielers
spiers84421743sp__iers
spikers135311993sp_ikers
spillers103311703spillers
spinels94512443sp_inels
spines85132033sp_ine_s
spinets94714813sp_inets
spinner93912263spinner_
spinnery13416593spinnery
spinneys13335553spinneys
spinors939423sp_inors
spitters104113383spitters
splashers1445283splashers
splatters11327543splatters
splicers12338113splicers
splines94718893spline_s
splinters11277923splinters
spoilers10238633spoilers
spongers1137603spongers
spoofers13307323spoofers
spoolers10349363spoolers
spooneys13314583spooneys
sporters103714063sporters
spotters104313383spotters
spouters104011163spouters
sprawler1334653sprawler_
sprayers13367053sprayers
springers12309983springers
sprinters11329363sprinters
spryness1334003spryness
spudders12255633spudders
spurner9269653spurner_
spurrers10338463spurrers
spurters103311703spurters
sputters104012873sputters
squawkers2542483squawkers
stabbers12268733stabbers
stablers103611153stablers
stackers143413563stackers
staffers14247083staffers
stagers84116673sta_gers
staggers10379843staggers
stainer73614923stainer_
stalkers12369853stalkers
stammers123611523stammers
stampers124211603stampers
standers93514303standers
stanes64933403sta_ne_s
staplers103111203staplers
starers74522313sta_rers
starkers123712393starkers
starters83714773starters
starvers11459643starvers
staters73922343sta_ters
stayers103813633sta_yers
stoners74817953s_toners
strainers9510383strainers
stunners8277923stunners
swabbers15316743swabbers
swagers114211023swa_gers
swaggers13407223swaggers
swampers15317473swampers
swannery1433553swannery
swappers15358083swappers
swarmers1346323swarmers
swashers14389533swashers
swathers144512083swathers
swatters113911793swatters
swayers13398853swa_yers
swooners11336863swooners
tanners74018393_tanners
tawers94118603_taw_ers
tawneys13324773_tawneys
thawers13428483thaw_ers
trainers83114643trainers
trawlers113310203trawlers
uptowners1441933uptowners
vanners103612843_vanners
warners103315563_warners
weaners104613833wea_ners
yarners104312203_yarners
yawner12428473_yawner_
yawpers15346853_yawpers
yearners11346373yearners

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.420425454.8
2DLD Change Limit1461623497.17320376.7
3Display Results3493490.1402492.9
 (SQL Overall)1786913497.73323107.6
 
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.