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

402 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
spawning1429691(None) 
pawning134711411_pawning
spanning113311081spanning
awning105013392__awning
dawning124111012_dawning
fawning14409132_fawning
impawning1743422impawning
paining103920242_paining
panning104019392_panning
pawing124519552_paw_ing
prawning1446962prawning
saining83621392s_aining
saning75127642s_a_ning
sawing104323812s_aw_ing
scanning113310772scanning
shawing143514882shaw_ing
shawling1558222shawling
snawing113612482snaw_ing
spacing123614492spa_cing
spading113114382spa_ding
spaeing103413542spa_eing
spalling113213462spalling
spamming15317602spamming
spanking153911972spanking
sparging122611132sparging
sparing104823872spa_ring
sparking152812542sparking
sparling112714532sparling
sparring113112222sparring
spasming13227202spasming
spatting113111762spatting
spaying133014622spa_ying
speaning113512242speaning
spewing133110452spew_ing
spinning113310812spinning
splining11310772splining
spooning112811442spooning
spraining1248152spraining
sprawling15175122sprawling
spurning11258662spurning
staining9413372staining
staning83922242sta_ning
swanning12338812swanning
yawning14378342_yawning
aproning11311793aproning
aweing103911253__aweing
awing96827323__aw_ing
awnings11406713__awnings
baning95127833_ba_ning
banning103818233_banning
barning104320353_barning
bawling133813863_bawling
beaning103820683bea_ning
blawing134012753blaw_ing
braining113414683braining
branning112911093branning
brawling143210043brawling
browning14299643browning
caning94128623_ca_ning
canning103620133_canning
cawing124322613_caw_ing
chaining142810783chaining
chawing164813033chaw_ing
clawing133812673claw_ing
clowning14307253clowning
craning103620303cra_ning
crawling143110513crawling
crowning143510033crowning
damning114211633_damning
darning93817333_darning
dawing114819823_daw_ing
dawting123610673_dawting
deaning94020473dea_ning
downing123811673_downing
draining103312673draining
drawing123812053draw_ing
drawling13318673drawling
drowning13298363drowning
earning83418213_earning
fanning113615073_fanning
flawing143812563flaw_ing
frowning15307833frowning
gaining94015663_gaining
gawking16398823_gawking
gawping14418463_gawping
gnawing12377903gnaw_ing
gowning12258833_gowning
graining102813183graining
hawing134322353_haw_ing
hawking183711423_hawking
inspanning1343203inspanning
japanning1943383japanning
jawing174414963_jaw_ing
lapwing13308263lapw_ing
lawing104625283_law_ing
leaning83721203lea_ning
learning978553learning
loaning83614833loa_ning
manning103616383_manning
mawing124020803_maw_ing
meaning103918703mea_ning
moaning103714443moa_ning
opaquing2042313opaquing
opening1039923op_ening
opining10311743op_ining
owning104110333__owning
pacing114522753_pa_cing
packing164420723_packing
padding123412513_padding
paging104020403_pa_ging
paiking143814813_paiking
painting113614423_painting
pairing103716733_pairing
paling93530133_pa_ling
palling104024483_palling
palming123914013_palming
palping124112873_palping
panging113319113_panging
panini8314273_pa_nini
panino8315683_pa_nino
panting104025423_panting
parging113318603_parging
paring94236493_pa_ring
parking143423043_parking
parling103823763_parling
parring103222063_parring
parsing103819553_parsing
parting103527383_parting
pashing135120513_pashing
passing104318423_passing
pasting103826553_pasting
patining11312303_patining
patting103722343_patting
pausing103912813_pausing
paving124519743_pa_ving
paying123722163_pa_ying
peening103318303_peening
peining104619153_peining
penning103616493_penning
phoning13312053_phoning
pining93726533_p_ining
pinning103417853_pinning
plaining113911553plaining
planing103418253_planing
planning113610223planning
pruning10311733_pruning
psalming1375473psalming
pshawing1733523pshaw_ing
punning103414993_punning
raining83922693_raining
sabbing123314743s_abbing
sabeing102611863s_abeing
sabring102614843s_abring
sacking144122703s_acking
sacring103115983s_acring
sagging103116103s_agging
sailing83927373s_ailing
sainting93215733s_ainting
salting84120793s_alting
salving113913153s_alving
sanding93520603s_anding
sapling103217863s_apling
saponin9310263saponin_
saponine1039223saponine
saponins1039453saponins
sapping123519313s_apping
sashing114621473s_ashing
sassing84615553s_assing
sating74735453s_a_ting
saucing10311003s_aucing
saunaing937013s_aunaing
saving104724513s_a_ving
saying104325543s_a_ying
scabbing15277193scabbing
scalding12339393scalding
scaling103519373sca_ling
scalping133410453scalping
scamming15328543scamming
scamping153510193scamping
scannings12264823scannings
scanting113914763scanting
scaping123715693sca_ping
scarfing14309713scarfing
scaring103421973sca_ring
scarping133312463scarping
scarring112511513scarring
scarting113415263scarting
scathing14269703scathing
scatting113311813scatting
scorning1169133scorning
scowing133812093scow_ing
scowling1458293scowling
scrawling15195583scrawling
seagoing1038193seagoing
sealing83528563sea_ling
seaming103222113sea_ming
searing83330923sea_ring
seasoning1037413seasoning
seating84130683sea_ting
seining84020773s_eining
sewing103819623s_ew_ing
shacking184014083shacking
shading123115563sha_ding
shafting15278683shafting
shagging14349053shagging
shaking153317253sha_king
shaming133016743sha_ming
shamming16289413shamming
shanking163612283shanking
shaping133116183sha_ping
sharing113723243sha_ring
sharking163912973sharking
sharping143011373sharping
shauling1249393shauling
shaving143414333sha_ving
sheening123010803sheening
shewing143812193shew_ing
shining113816523s_hining
shinning123211023shinning
showing143814663show_ing
showring1548323showring
shrining122610853shrining
shunning12367843shunning
signing92713963s_igning
sinning83918443s_inning
siphoning1546133siphoning
skanking12288743skanking
skating123613853ska_ting
skeining1347073skeining
skewing15318723skew_ing
skinning13327893skinning
slabbing13287783slabbing
slacking153914133slacking
slagging113711583slagging
slaking123717473sla_king
slamming133310003slamming
slanging103413433slanging
slanting94115093slanting
slapping133510843slapping
slashing123713413slashing
slating83724653sla_ting
slatting94014233slatting
slaving113514833sla_ving
slaying113316843sla_ying
slewing113311353slew_ing
slowing112814743slow_ing
smacking173510763smacking
smarting113212453smarting
smashing143310243smashing
snacking153411703snacking
snafuing1235083snafuing
snagging11319373snagging
snailing92912973snailing
snaking123915303sna_king
snapping13349653snapping
snarfing12358663snarfing
snaring83920953sna_ring
snarling92513183snarling
snowing113913453snow_ing
soaking123116613soa_king
soaping103616223soa_ping
soaring83521893soa_ring
sorning83116813s_orning
sowing104222913s_ow_ing
spacings13287043spa_cings
spackling18266503spackling
spaeings11276253spa_eings
spang84919733spa___ng
spangling1336373spangling
spaniel948923spa_niel
spankings16215003spankings
sparkling16226353sparkling
sparlings12257153sparlings
spartina1037983spartina
spavin114210653spa_vin_
spavins12419323spa_vins
spawn107811713spaw__n_
spawned13316803spawn_ed
spawner12347363spawn_er
spawners13396493spawners
spawns11577923spaw__ns
speaking153212493speaking
spearing113216103spearing
speccing15306643speccing
specking17359733specking
speeding122810933speeding
speeling112713123speeling
speering113116323speering
speiling113612973speiling
speiring113711263speiring
spelling113315233spelling
spending122712433spending
sphering142811943sphering
spicing123914533sp_icing
spieling113212523spieling
spiering112713353spiering
spiffing17237083spiffing
spiking144312883sp_iking
spiling102919703sp_iling
spilling113113943spilling
spinnings12294853spinnings
spiring103918183sp_iring
spirting112913633spirting
spiting103917623sp_iting
spitting113012323spitting
splashing1535703splashing
splatting1235983splatting
splaying14219303splaying
splicing1338963splicing
splinting1238193splinting
spoiling112911553spoiling
spoking143212223sp_oking
sponging1238823sponging
spoofing14228363spoofing
spooking15269803spooking
spooling113212563spooling
spooring113111463spooring
sporing104319413sp_oring
sporting112415463sporting
spotting112812093spotting
spousing11198733spousing
spouting113511953spouting
spraying14299883spraying
spring94526013sp__ring
springing1338743springing
sprinting12310033sprinting
sprucing1336893sprucing
spudding1335653spudding
spuing94313363sp__uing
spuming1248523sp_uming
spunking15258063spunking
spurring11339763spurring
spurting113111633spurting
spying123913253sp__ying
squawking2642433squawking
stabbing13238763stabbing
stabling112913653stabling
stacking154215083stacking
staffing15247493staffing
stagging113310513stagging
staging93818373sta_ging
staking123919803sta_king
staling83925423sta_ling
stalking133512223stalking
stalling95116703stalling
stamping133310963stamping
standing103413633standing
stanging104013653stanging
stanine73417073sta_nine
stapling112813153stapling
staring84527053sta_ring
starling93017123starling
starring92312953starring
starting93116173starting
starving122510173starving
stashing123511583stashing
stating83725163sta_ting
staving113915703sta_ving
staying114017323sta_ying
stewing113412493stew_ing
stoning83717443s_toning
stowing113315133stow_ing
straining10410563straining
strawing122411623straw_ing
stunning9298463stunning
sunning83715673s_unning
swabbing16246453swabbing
swagging14328093swagging
swaging124210633swa_ging
swamping16307923swamping
swanking16399963swanking
swapping16348673swapping
swarding1359003swarding
swarming1458223swarming
swashing15369743swashing
swathing15248713swathing
swatting12309593swatting
swaying143610643swa_ying
swing96124843s__w_ing
swooning12278203swooning
swouning12246563swouning
syphoning1845393syphoning
tanning83618253_tanning
tawing104521553_taw_ing
tawsing1138673_tawsing
thawing14378683thaw_ing
training93015863training
trawling122710783trawling
unwaning1238133unwaning
upswing1335593upsw_ing
vanning113912463_vanning
waning103623803_wa_ning
wanning113816213_wanning
warning113717093_warning
wawling143810963_wawling
weaning114117193wea_ning
yarning113512953_yarning
yawing134215613_yaw_ing
yawling14369183_yawling
yawping16357333_yawping
yeaning113814633yea_ning
yearning1296983yearning

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 Limit1461624026.78021557.8
3Display Results4024020.1562576.9
 (SQL Overall)1786914027.37224239.1
 
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.