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

492 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
spawned1331680(None) 
pawned124513281_pawned
spanned104111221spanned
spawner12347361spawner
awned96615952__awned
dawned113912092_dawned
fawned134910422_fawned
impawned1643442impawned
pained95622852_pained
paned85437182_pa_ned
panned94123432_panned
pawed115725612_paw_ed
pawnee113115402_pawnee
pawner114212922_pawner
prawned1346742prawned
sained75424242s_ained
saned65636272s_a_ned
sawed95628402s_aw_ed
sawney12387602s_awney
scanned104110892scanned
seaweed11108812seaweed
shawed134817232shaw_ed
shawled1437772shawled
snawed104813732snaw_ed
spaced114517252spa_ced
spaded103816752spa_ded
spaed85522272spa__ed
spalled103113122spalled
spammed14348522spammed
spanked143111722spanked
spanner94312562spanner
spared95427482spa_red
sparged113512752sparged
sparked143513132sparked
sparred104512852sparred
spasmed12296992spasmed
spathed134013182spathed
spatted104014142spatted
spavined1434332spavined
spawn107811712spawn__
spawners13396492spawners
spawns11577922spawn_s
spayed124213612spa_yed
speaned103411522speaned
spewed125512332spew_ed
spined95423942sp_ined
splined105013112splined
spooned103412442spooned
sprained1138432sprained
sprawled1434512sprawled
spurned10339262spurned
stained84215342stained
staned74824642sta_ned
swanned11358172swanned
yawned13509842_yawned
acned87520663__acned
aproned10311503aproned
awed88436033__aw_ed
baned85436353_ba_ned
banned94721343_banned
barned95623583_barned
bawled124415693_bawled
beaned95621473bea_ned
blawed124713893blaw_ed
brained103816103brained
branned104311693branned
brawled133910123brawled
browned134710973browned
caned85838093_ca_ned
canned95022063_canned
cawed116627063_caw_ed
chained133812693chained
chawed155214603chaw_ed
clawed125115073claw_ed
clowned13447723clowned
craned96121653cra_ned
crawled133710393crawled
crowned133912423crowned
damned104212913_damned
darned85018483_darned
dawed106222813_daw_ed
dawted11489683_dawted
deaned84620453dea_ned
downed115314783_downed
drained93713253drained
drawled12368343drawled
drowned12419903drowned
earned74818333_earned
fanned104117473_fanned
fawner125910463_fawner
flawed134712723flaw_ed
frowned14348833frowned
gained84617463_gained
gawked15468763_gawked
gawped13509073_gawped
gnawed11427833gnaw_ed
gowaned1235763gowaned
gowned114410133_gowned
grained93814273grained
hawed126025423_haw_ed
hawked174712673_hawked
inspanned1242853inspanned
japanned1843143japanned
jawed165517373_jaw_ed
jeaned143813463jea_ned
lawed96028323_law_ed
leaned73422543lea_ned
learned8329303learned
loaned73816293loa_ned
maned86634093_ma_ned
manned94418643_manned
mawed115824743_maw_ed
moaned94514173moa_ned
opaqued1942193opaqued
opened94311863op_ened
opined95113853op_ined
owned95113233__owned
paced106931683_pa_ced
packed154822603_packed
padded114113503_padded
paged95926783_pa_ged
paiked135113433_paiked
painted104214633_painted
paired95017523_paired
paled85538723_pa_led
palled94625163_palled
palmed114314643_palmed
palped114513643_palped
pane64950283_pa_ne_
panel76023623_pa_nel
panes76148693_pa_nes
panged104722333_panged
panne76623653_panne_
panner84224763_panner
pannes85522853_pannes
panted95024823_panted
pared86946763_pa_red
parged104922033_parged
parked134425133_parked
parled94626273_parled
parred95024073_parred
parsed96323893_parsed
parted94228683_parted
pashed125923143_pashed
passed94320943_passed
pasted94426903_pasted
pated85237843_pa_ted
patined105114783_patined
patted94724683_patted
paused95114963_paused
paved115525263_pa_ved
paveed12438893_paveed
pawer104422973_paw_er
pawn94625303_pawn__
pawnees12298173_pawnees
pawners124311073_pawners
pawnor11357243_pawnor
pawns108818133_pawn_s
payed115925933_pa_yed
peened94318153_peened
peined94918843_peined
penned94217613_penned
phoned124014553_phoned
pined85935323_p_ined
pinned94818383_pinned
plained103812233plained
planed94420913_planed
planned103810153planned
prawner1246803prawner
pruned93413113_pruned
psalmed1234503psalmed
pshawed16103033pshaw_ed
punned93416193_punned
rained75024603_rained
sabbed114518083s_abbed
sabed86526813s_a_bed
sabred95916533s_abred
sacked135525213s_acked
sacred94917103s_acred
sagged94120003s_agged
sailed74327763s_ailed
sainted84114243s_ainted
salted74121203s_alted
salved103916423s_alved
sand55338463s_a_n_d
sanded84920613s_anded
sane45954333s_a_ne_
saner54334323s_a_ner
sanes55649073s_a_nes
sapped114422013s_apped
sapwood1366913sapwood
sashed105622943s_ashed
sassed76116173s_assed
sated66238533s_a_ted
sauced93913303s_auced
saunaed836703s_aunaed
sauted74119603s_auted
saved95127113s_a_ved
sawer85026213s_aw_er
sawn75428163s_awn__
sawneys13274643s_awneys
sawyer12438043s_awyer
sayed96127143s_a_yed
scabbed14408223scabbed
scalded11409763scalded
scaled94822443sca_led
scalped124411993scalped
scammed14479543scammed
scamped144711963scamped
scanner94411813scanner
scanted104114393scanted
scaped115519553sca_ped
scared95227293sca_red
scarfed134711183scarfed
scarped124314393scarped
scarred104512633scarred
scarted104816123scarted
scathed134012643scathed
scatted103512773scatted
scorned10229953scorned
scowed124413823scow_ed
scowled13398183scowled
scrawled1445903scrawled
seabed95017693sea_bed
sealed74328363sea_led
seamed94823883sea_med
seared75232843sea_red
seasoned948113seasoned
seated75131053sea_ted
seaward1148173seaward
seaweeds12104453seaweeds
seined74023063s_eined
sepaled10510593sepa_led
sepalled1156903sepalled
sewed95325163s_ew_ed
shacked174015393shacked
shaded114518873sha_ded
shafted14288803shafted
shagged134210123shagged
shaled105023953sha_led
shamed125120213sha_med
shammed153911423shammed
shanked153212123shanked
shaped125020103sha_ped
shared105829063sha_red
sharked153613903sharked
sharped134112043sharped
shauled1148793shauled
shaved135118383sha_ved
shawn116417613shawn__
sheened113511703sheened
shewed134716183shew_ed
shined104620783s_hined
shinned114310913shinned
showed135016963show_ed
shrined114112413shrined
shunned11417843shunned
signed83413753s_igned
sinned73818413s_inned
siphoned1446413siphoned
skanked11338103skanked
skated114414873ska_ted
skeined1236773skeined
skewed145610233skew_ed
skinned12387293skinned
slabbed12409503slabbed
slacked143815453slacked
slagged104312763slagged
slaked114318273sla_ked
slammed123511103slammed
slanged94112853slanged
slanted83514743slanted
slapped123511843slapped
slashed114114853slashed
slated75028313sla_ted
slatted84015183slatted
slaved104017043sla_ved
slayed104716223sla_yed
slewed104815523slew_ed
slowed104617073slow_ed
smacked163710993smacked
smarted105012613smarted
smashed133711223smashed
snacked144013113snacked
snafued1134933snafued
snagged104010663snagged
snailed83811923snailed
snaked115017593sna_ked
snapped124611203snapped
snapweed1443453snapweed
snared74824553sna_red
snarfed11378753snarfed
snarled83612353snarled
sned56026053s___ned
snowed104613613snow_ed
soaked114717593soa_ked
soaped95817973soa_ped
soared74324293soa_red
sorned74820043s_orned
sowed94933863s_ow_ed
space95325673spa_ce_
spacer104917793spa_cer
spaces104722633spa_ces
spacey136212533spa_cey
spacier114011633spacier
spackled17297793spackled
spade84423323spa_de_
spader94317133spa_der
spades94222583spa_des
spadones1137253spadones
spae65034323spa__e_
spaes76029973spa__es
spahee11313443spa_hee
spahees1238263spahees
spake114322743spa_ke_
spale74929213spa_le_
spales84728103spa_les
spaller92713473spaller
spammer133410433spammer
span65234663spa_n__
spancel1147363spancel
spandex1735833spandex
spang84919733spa_n_g
spangled1236143spangled
spaniel948923spaniel
spank115919573spa_n_k
spanker133612353spanker
spanks124514123spa_nks
spanners103710773spanners
spans74528733spa_n_s
spare75135563spa_re_
sparer84524963spa_rer
spares84834553spa_res
sparge94216043sparge_
sparger103613073sparger
sparges104016333sparges
sparid94016933spa_rid
sparker133914353sparker
sparkled15317723sparkled
sparoid102311533sparoid
sparse84516343sparse_
sparser94311483sparser
spate74731583spa_te_
spates85028173spa_tes
spathe115115693spathe_
spathes125116533spathes
spatter94016523spatter
spavie113611383spavie_
spavies123012943spavies
spaviet123011923spaviet
spawning14296913spawning
spazzes1735263spazzes
speared104314423speared
specced14266703specced
specked16329013specked
sped76031493sp___ed
speed85526623sp__eed
speeded113310423speeded
speeled103712453speeled
speered103614813speered
speiled104412123speiled
speired103811103speired
spelled103714733spelled
spend85619333sp_en_d
spewer115112143spew_er
sphene113412403sphene_
sphenes123013163sphenes
sphered133512313sphered
spiced115218313sp_iced
spied85427713sp__ied
spieled104811883spieled
spiered104412463spiered
spiffed16257103spiffed
spiked134915553sp_iked
spiled94621993sp_iled
spilled103613623spilled
spine76534423sp_ine_
spinel85317333sp_inel
spines85132033sp_ines
spinet85629753sp_inet
spinner93912263spinner
spinney12438923spinney
spired94921863sp_ired
spirted103913073spirted
spited94820443sp_ited
spitted103912703spitted
splashed1435593splashed
splatted11356743splatted
splayed13357813splayed
spliced124310593spliced
spline86020533spline_
splines94718893splines
splinted11369253splinted
spoiled104811353spoiled
spoked134413893sp_oked
sponged1137953sponged
spoofed13399103spoofed
spooked144510473spooked
spooled104613523spooled
spooney12418243spooney
spoored104411293spoored
spored94821793sp_ored
sported104015433sported
spotted103713133spotted
spoused10349653spoused
spouted103412263spouted
sprawler1334643sprawler
sprayed13398903sprayed
springed123911313springed
sprinted113411163sprinted
spruced12307523spruced
spudded12235903spudded
spued84918473sp__ued
spumed114711543sp_umed
spunked14307783spunked
spurner9269653spurner
spurred103610613spurred
spurted103111973spurted
squawked2543013squawked
stabbed123510373stabbed
stabled103514953stabled
stacked143416123stacked
staffed14298283staffed
staged84521563sta_ged
stagged104212073stagged
stainer73614923stainer
staked114621943sta_ked
staled74728103sta_led
stalked123811173stalked
stalled83515683stalled
stamened1137633stamened
stamped124812813stamped
stand65923283sta_n_d
stane55933003sta_ne_
stanes64933403sta_nes
stanged94113843stanged
stapled103613693stapled
stared75429873sta_red
starred85013453starred
started84217323started
starved114911573starved
stashed113812483stashed
stated75427833sta_ted
statued8459893statued
staved103918053sta_ved
stayed104817273sta_yed
stewed104814243stew_ed
stoned75923143s_toned
stowed105817203stow_ed
strained9412253strained
strawed114813613straw_ed
stunned8358893stunned
sunned74216323s_unned
swabbed15367403swabbed
swacked173110523swacked
swaged114212253swa_ged
swagged13419143swagged
swamped15498443swamped
swanked15359543swanked
swapped15429143swapped
swarded1238153swarded
swarmed1367483swarmed
swashed144311363swashed
swathed144611933swathed
swatted114110693swatted
swayed133510263swa_yed
swooned11368593swooned
swouned11366663swouned
syphoned1745733syphoned
tanned75219953_tanned
tawed95926193_taw_ed
tawney12338233_tawney
tawsed10499743_tawsed
thawed13458463thaw_ed
trained84117203trained
trawled113411523trawled
unawed103914903unaw_ed
unowned1148803unowned
vaned94622423_va_ned
vanned104614483_vanned
waned95831783_wa_ned
wanned104318013_wanned
warned104018913_warned
wawled133811703_wawled
weaned103816153wea_ned
yarned105514023_yarned
yawed126022453_yaw_ed
yawled13459983_yawled
yawner12428473_yawner
yawped15528103_yawped
yeaned103813903yea_ned
yearned11327373yearned

Search took 9 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274927.73317331.8
3Display Results4924920.2032423.6
 (SQL Overall)1786914928.09222082.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.