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

430 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
scarlet9151694(None) 
scarlets10178571scarlets
starlet71620121starlet
cablet104429462_cablet
callet84536762_callet
camlet104426582_camlet
caplet104226812_caplet
caret75360562_car_et
carle74535702_carle_
carles85435082_carles
carnet84732872_carnet
carpet104530092_carpet
sallet63734542s_allet
samlet84126562s_amlet
scale74629142sca_le_
scaled94822442sca_led
scaler84321602sca_ler
scales84529312sca_les
scarce104013632scarce_
scarcer113911372scarcer
scarcest12169172scarcest
scare75334462scar_e_
scared95227292scar_ed
scarer84524612scar_er
scares85033002scar_es
scarey115016982scar_ey
scarfed134711182scarfed
scarfer124511082scarfer
scarier94017872scarier
scariest101615952scariest
scarless10189052scarless
scarped124314402scarped
scarper114814822scarper
scarred104512632scarred
scart76139772scar__t
scarted104816122scarted
scarves124511622scarves
snarled83612362snarled
snarler73610632snarler
sparklet143110592sparklet
starlets81610082starlets
starlit71512912starlit
sterlet71318472sterlet
varlet9423502_varlet
aglet65534143__aglet
arles56735743__arles
armet76739453__armet
armlet84118193__armlet
ascared10399523ascar_ed
ballet84733973_ballet
barbet104427883_barbet
barley115116763_barley
barret84930483_barret
becarpet1447533becarpet
cable95329913_cable_
cabled114819873_cabled
cabler104519173_cabler
cables104527553_cables
cablets114216343_cablets
cachet134526413_cachet
cadet85339343_ca_det
called94126733_called
callee84327293_callee
caller85125483_caller
callets93821703_callets
camlets114314623_camlets
capelet11517073_capelet
caplets114914523_caplets
carat75048793_car_at
carate84734003_carate
carcel105018673_carcel
carded105424903_carded
carder94524183_carder
care66968373_car_e_
cared86050093_car_ed
careen84119493_careen
career85822243_career
carer74942333_car_er
cares77369183_car_es
carets85330773_car_ets
carex144822303_car_ex
caried94528693_caried
caries85147623_caries
carked134024823_carked
carl65144783_carl__
carless95118493_carless
carlin84421823_carlin
carls77037423_carl_s
carmen104019343_carmen
carnets93918403_carnets
carney115315703_carney
caroled103717693_caroled
caroler93816753_caroler
carped115923763_carped
carpel105418473_carpel
carper104923633_carper
carpets113915333_carpets
carrel84718633_carrel
carrot8423123_carrot
carse74934333_carse_
carses85233653_carses
cart66570343_car__t
carte75940423_carte_
carted98631443_carted
cartel85022533_cartel
carter84932273_carter
cartes86239473_cartes
carve106227753_carve_
carved124320853_carved
carvel114817573_carvel
carven114716663_carven
carver114420153_carver
carves115128453_carves
casket124820993_casket
caules85927253_caules
cermet10321153_cermet
chalet113825993_chalet
chaplet14512253chaplet
charley15118273charley
circlet11311473_circlet
claret84026573clar_et
collet84030363_collet
cornet84436733_cornet
corset85636223_corset
corslet9318063_corslet
corvet114626933_corvet
cruet74831843_c_ruet
culet76040343_c_ulet
cullet84727313_cullet
curet75447643_cur_et
curled95021653_curled
curler85221323_curler
curlew114010903_curlew
curvet114720243_curvet
cutlet84924363_cutlet
eaglet73722583_eaglet
ecarte84313503ecarte_
ecartes94212563ecartes
epaulet939513epaulet
escargot1183863escargot
escarole1045743escarole_
escaroles1145273escaroles
escarped1355163escarped
farle86929243_farle_
farles96025783_farles
flatlet10312253flatlet
foscarnet1444453foscarnet
gallet73630853_gallet
garget84327273_garget
garnet73928413_garnet
garret74426563_garret
gnarled9287723gnarled
hamlet113722793_hamlet
harlot94422803_harlot
harslet10315653_harslet
haslet93222713_haslet
imaret81121233imar_et
leaflet10199743leaflet
mallet84433053_mallet
market123226043_market
marled95523163_marled
martlet93419153_martlet
overlet102619033overlet
palet74650803_pa_let
pallet84232653_pallet
parget94529393_parget
parle75836163_parle_
parled94626293_parled
parles86334403_parles
parley116718363_parley
partlet92720363_partlet
pearled10411553pearled
pearler9310373pearler
playlet1239523playlet
quartet162814893quartet
recarpet12310603recarpet
sable74732163s_able_
sables85026693s_ables
sachet114725773s_achet
sacred94917103sacr_ed
sacrist9315423sacrist
sailed74327763s_ailed
sailer63526103s_ailer
sale44959703s_a_le_
salep77022953s_a_lep
sales56055593s_a_les
sallets73719653s_allets
salt45758523s_a_l_t
samlets93813553s_amlets
saree55044663s_ar_ee
sarees65329943s_arees
sarge65531133s_arge_
sarges75128593s_arges
sarment9318763s_arment
sarsen6314233s_arsen
sarsnet7314813s_arsnet
sault55834963s_aul_t
scabbed14408223scabbed
scabble13168653scabble_
scabbled15156303scabbled
scabbles14167983scabbles
scabies11613333scabies
scalar83612433sca_lar
scald84818123sca_l_d
scalded11409763scalded
scalds94813693sca_lds
scalene9310773sca_lene
scaleni936883sca_leni
scalers93817263sca_lers
scaleup1134483sca_leup
scalier94316913scalier
scaliest101714403scaliest
scall74420373sca_l_l
scallop11237643scallop
scalls84218203sca_lls
scalp95217983sca_l_p
scalped124411993scalped
scalpel11377713scalpel
scalper113912923scalper
scalps104315233sca_lps
scaly104718723sca_l_y
scammed14479543scammed
scammer133611973scammer
scamped144711963scamped
scamper134613163scamper
scandent1148493scandent
scanned104110893scanned
scanner94411813scanner
scant79735073sca__nt
scanted104114393scanted
scanter94215183scanter
scantest101710183scantest
scape96921843sca_pe_
scaped115519553sca_ped
scapes105122263sca_pes
scar66434203scar___
scarab10310063scar_ab
scarabs1137293scarabs
scarcely1534313scarcely
scarcity1545093scarcity
scareder1135793scareder
scaredest1246633scaredest
scarers94618513scarers
scarf105427143scar__f
scarfers13408463scarfers
scarfs114714683scar_fs
scarify1537443scarify
scarily12311703scarily
scaring103421973scaring
scarp95724103scar__p
scarpers124712513scarpers
scarph13429603scar_ph
scarphed1635443scarphed
scarphs14437413scarphs
scarps104718603scar_ps
scarrier10298453scarrier
scarriest11188403scarriest
scarry116311183scar_ry
scars75433533scar__s
scarts85321493scar_ts
scary105222593scar__y
scat65848373sca___t
scathe114414993scathe_
scathed134012643scathed
scathes124515713scathes
scatt76030093sca__tt
scatted103512773scatted
scatter93815173scatter
scauper11379453scauper
schlep1347093sc_hlep
scolex1538243sc_olex
score75526743scor_e_
scored94621133scor_ed
scorer84818263scor_er
scores84725923scor_es
scorned10229953scorned
scorner9259763scorner
scowled13398193scowled
scowler12248193scowler
scramjet1945033scramjet
scrape105917573scrape_
scraped124313133scraped
scraper114513423scraper
scrapes116217663scrapes
scrawled1445923scrawled
scrawler1345893scrawler
scree720031713sc_r_ee
screed95718933sc_reed
screen85216023sc_reen
screes85023973sc_rees
screw109318543sc_r_ew
scried95817303sc_ried
scries85226823sc_ries
script105717903sc_ript
sculled102911693sculled
sculler99812153sculler
sculpt104412693sc_ulpt
sealed74328363sea_led
sealer63928963sea_ler
seared75232843sear_ed
searer65432023sear_er
searest73322023searest
secret8325063secr_et
shale85332833sha_le_
shaled105023953sha_led
shales94731253sha_les
shaley123714993sha_ley
shallot103614133shallot
shalt85534493sha_l_t
share86437083shar_e_
shared105829063shar_ed
sharer95025483shar_er
shares95236413shar_es
sharked153613913sharked
sharker144313813sharker
sharped134112053sharped
sharpen12389723sharpen
sharper124312703sharper
sharpest1339153sharpest
shauled1148793shauled
shawled1437773shawled
sherbet12311383sherbet
singlet84120113singlet
skillet113512153skillet
skirled12348183skirled
skirret11278173skirret
smaller93410333smaller
smallest1039403smallest
smalt74729333sma_l_t
smart75834093smar__t
smarted105012613smarted
smarten9348863smarten
smarter94113133smarter
smartest10310183smartest
snailed83811923snailed
snare54429983snar_e_
snared74824553snar_ed
snarer64620843snar_er
snares65329033snar_es
snarfed11378753snarfed
snarl54921083snarl__
snarlers8298753snarlers
snarlier8278183snarlier
snarliest91810213snarliest
snarls64016873snarl_s
snarly93815003snarl_y
sniglet83612413sniglet
soared74324293soar_ed
soarer64522243soar_er
sorbet83924083s_orbet
spale74929213spa_le_
spales84728103spa_les
spalled103113133spalled
spaller92713473spaller
spare75135563spar_e_
spared95427493spar_ed
sparely123410673sparely
sparer84524963spar_er
spares84834553spar_es
sparest94616433sparest
sparge94216053sparge_
sparged113512763sparged
sparger103613083sparger
sparges104016343sparges
sparked143513143sparked
sparker133914363sparker
sparkle133710213sparkle_
sparkled15317733sparkled
sparkler14317983sparkler
sparkles143210493sparkles
sparklets15275843sparklets
sparred104512863sparred
sparse84516343sparse_
sparser94311483sparser
sparsest1048823sparsest
spaviet123011933spaviet
stable83921643stable_
stabled103514953stabled
stabler94014933stabler
stables93219073stables
stablest103312943stablest
stale55637103sta_le_
staled74728103sta_led
staler64025823sta_ler
stales65538293sta_les
stalest73720173sta_lest
stalled83515693stalled
staple84415823staple_
stapled103613703stapled
stapler93913633stapler
staples93617213staples
stare54440263star_e_
stared75429873star_ed
starer64027363star_er
stares66038753star_es
starets73515923star_ets
starker114114693starker
starkest1239723starkest
starless81610843starless
starred85013453starred
start55642313star__t
started84217323started
starter73817883starter
startle72511123startle_
startled9208563startled
startler8248793startler
startles82111963startles
starve94613743starve_
starved114911573starved
starver104611993starver
starves104614553starves
sterlets8169273sterlets
street64125773s_treet
stylet94018573s_tylet
suable83920553suable_
sublet82827243s_ublet
swale85221593swa_le_
swales93920763swa_les
swarded1238153swarded
sware85828213swar_e_
swarmed1367483swarmed
swarmer1247803swarmer
swart86234643swar__t
swirled11308223swirled
tablet84227643_tablet
target75028903_target
tartlet72218483_tartlet
valet84337873_va_let
varlets10411573_varlets
wallet93327093_wallet

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 Filter1786911340270.406440125.6
2DLD Change Limit1340274306.34321129.9
3Display Results4304300.1403071.4
 (SQL Overall)1786914306.88925938.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.