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

325 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
starlets8161008(None) 
scarlets10178571scarlets
starets73515921star_ets
starless81610841starless
starlet71620121starlet_
sterlets8169271sterlets
sallets73719652s_allets
samlets93813552s_amlets
scarless10189052scarless
scarlet91516942scarlet_
snarlers8298752snarlers
sparklets15275842sparklets
stablers103611152stablers
stables93219072stable_s
stablest103312942stablest
stairless9185622stairless
stales65538292sta_le_s
stalest73720172sta_lest
staplers103111202staplers
staples93617212staple_s
starers74522312star_ers
stares66038752star_e_s
starkers123712392starkers
starkest1239722starkest
starlit71512912starlit_
starters83714772starters
startlers9236742startlers
startles82111962startle_s
starts65423122star__ts
starvers11459642starvers
starves104614552starve_s
sterlet71318472sterlet_
streets73312612st_reets
stylets10369212st_ylets
tablets94714382_tablets
targets84314222_targets
tartlets8289662_tartlets
varlets10411572_varlets
aglets73915683__aglets
arles56735743__arle_s
armets84918353__armets
armlets94610063__armlets
ballets93719513_ballets
barbets114915843_barbets
barless94317003_barless
barleys125011843_barleys
barrets94917103_barrets
cablets114216343_cablets
callets93821703_callets
camlets114314623_camlets
caplets114914523_caplets
carets85330773_car_ets
carles85435083_carle_s
carless95118493_carless
carnets93918403_carnets
carpets113915333_carpets
chalets122813473cha_lets
chaplets1556883chaplets
charleys1695633charleys
clarets94111103clar_ets
eaglets84111663_eaglets
earless74316073_earless
epaulets1043733epaulets
farles96025783_farle_s
fearless1137873fearless
flatlets1147373flatlets
gallets83517403_gallets
gargets94614573_gargets
garnets84115403_garnets
garrets84413623_garrets
gearless937373gearless
hamlets123211403_hamlets
harlots103413293_harlots
harslets1137833_harslets
haslets102510863_haslets
imarets9138643imar_ets
leaflets11244813leaflets
mallets93318493_mallets
markets133314033_markets
martlets103310483_martlets
oarless73913373_oarless
overlets112312363overlets
palets85122313_pa_lets
pallets93919303_pallets
pargets105215193_pargets
parles86334403_parle_s
parleys125212373_parleys
partlets102811513_partlets
pearlers1039033pearlers
playlets1334903playlets
quartets17277573quartets
retargets1045303retargets
sables85026693s_able_s
sachets123914103s_achets
sailers73822323s_ailers
saleps85014903s_a_leps
sales56055593s_a_le_s
sallet63734543s_allet_
salts55431883s_a_l_ts
samlet84126563s_amlet_
sapless93313443s_apless
sarees65329943s_ar_ees
sarges75128593s_arge_s
sarments10311963s_arments
sarsens7311393s_arsens
sarsnets836783s_arsnets
satinets8311733satinets
saults65816173s_aul_ts
scalers93817263sca_lers
scales84529313sca_le_s
scarcest12169173scarcest
scarers94618513scar_ers
scares85033003scar_e_s
scarfers13408463scarfers
scariest101615953scariest
scarpers124712513scarpers
scarts85321493scar__ts
scarves124511623scarve_s
sealers74323553sea_lers
seamless10238723seamless
searest73322023sear_est
seatless83213003seatless
secrets9311773secr_ets
shales94731253sha_le_s
shallots11319503shallots
sharers104720623shar_ers
shares95236413shar_e_s
sharkers154011053sharkers
sharpens13377813sharpens
sharpers133810943sharpers
sharpest1339153sharpest
shearlegs1342493shearlegs
sherbets1335213sherbets
singlets93611473singlets
sitarists949373sitarists
skillets12226823skillets
skirrets12244013skirrets
smallest1039403smallest
smalts85214893sma_l_ts
smartens10286663smartens
smartest10310183smartest
smarts86218003smar__ts
snapless10287463snapless
snarers74216663snar_ers
snares65329033snar_e_s
snarled83612363snarle_d
snarler73610633snarle_r
snarliest91810213snarliest
snarls64016873snarl__s
sniglets9276813sniglets
soapless10278073soapless
soarers74118093soar_ers
sorbets93012513s_orbets
spales84728103spa_le_s
spallers102910733spallers
spanless10247363spanless
sparers94519613spar_ers
spares84834553spar_e_s
sparest94616433spar_est
spargers11389733spargers
sparges104016343sparge_s
sparkers144111313sparkers
sparklers15315643sparklers
sparkles143210493sparkle_s
sparklet143110593sparklet_
sparsest1048823sparsest
stabbers12268733stabbers
stabiles10311403stabile_s
stable83921643stable__
stabled103514953stable_d
stabler94014933stable_r
stackers143413563stackers
stackless1555933stackless
stactes91914633stacte_s
staddles10258693staddle_s
stades74626243sta_de_s
staffers14247083staffers
stagers84116673sta_gers
stages75629493sta_ge_s
staggers10379843staggers
stagiest91613413stagiest
staidest939803staidest
stainers83212173stainers
stainless9176493stainless
stakes103927293sta_ke_s
stalags838643sta_lags
stale55637103sta_le__
staled74728103sta_le_d
stalely1039213sta_lely
staler64025823sta_le_r
stalkers12369853stalkers
stalkless1333723stalkless
stalks104614553sta_l_ks
stalled83515693stalle_d
stalls64019933sta_l_ls
stamens93411483sta_mens
stammels12495563stammels
stammers123611523stammers
stampers124211603stampers
stampless1334543stampless
stances93715963stance_s
standees93310143standees
standers93514303standers
stanes64933403sta_ne_s
stapes85028733sta_pe_s
staple84415823staple__
stapled103613703staple_d
stapler93913633staple_r
starches131912913starches
stardoms1136793stardoms
stardust946093stardust
stardusts1043153stardusts
stare54440263star_e__
stared75429873star_e_d
starer64027363star_e_r
starker114114693starke_r
starkness1335963starkness
starlights1443983starlights
starlike1238813starlike
starling93017123starling
starlings10237923starlings
starred85013453starre_d
starriest9159773starriest
stars55836573star___s
start55642313star__t_
started84217323starte_d
starter73817883starte_r
startle72511123startle__
startled9208563startle_d
startler8248793startle_r
startsy10536703star__tsy
startups1033893startups
starve94613743starve__
starved114911573starve_d
starver104611993starve_r
starworts12105273starworts
stases64225563sta_se_s
stashes103916173stashe_s
stateless937563stateless
staters73922343sta_ters
states64337083sta_te_s
statists8310163statists
stats55933363sta___ts
statues74614903statue_s
statutes8368893statutes
staves94525193sta_ve_s
stayers103813633sta_yers
stealers83412213stealers
stearates939453stearates
steles63725663st_ele_s
stemless1036653stemless
stereos74314973ster_eos
steres63929533ster_e_s
sternest8314433sternest
stets55423913st___ets
stiflers11238833stiflers
stifles103013393stifle_s
stiles64328773st_ile_s
stillest8311073stillest
stilts67915313st_il_ts
stirpes95011293stirpe_s
stirrers8266943stirrers
stoles63927673st_ole_s
stollens835293stollens
storers75018683stor_ers
stores65533663stor_e_s
storeys10559653stor_eys
stories7324273storie_s
strafers11379913strafers
strafes104516003strafe_s
straits74916323st_raits
strakes114218073strake_s
strapless1135793strapless
strayers113510143strayers
streamlets1243073streamlets
streeks11378713st_reeks
streels73811343st_reels
street64125773st_reet_
streps86218063st_r_eps
stress66616673st_r_ess
strews96817103st_r_ews
strunts7429543st_runts
struts65616803st_r_uts
sturts63915143stur__ts
stylers10359353st_ylers
styles94418653st_yle_s
stylet94018573st_ylet_
sublets92616703s_ublets
sugarless1043673sugarless
swales93920763swa_le_s
swarmers1346323swarmers
tables84524893_table_s
tablet84227643_tablet_
tackets134914363_tackets
tailers73720183_tailers
talents7312013_ta_lents
talers64628143_ta_lers
tales55451373_ta_le_s
tallest7317093_tallest
tallits73215993_tallits
tappets113610013_tappets
tares57456563_tar_e_s
targes74524593_targe_s
target75028903_target_
tarletan845543_tarletan
tarletans944653_tarletans
tarots66422993_tar_ots
tarres64723043_tarre_s
tartest72517533_tartest
tartlet72218483_tartlet_
tarts57242023_tar__ts
tassets75012773_tassets
taxless1436913_taxless
tearless848713tearless
tercets93512443_tercets
terrets72913583_terrets
toilets74112913_toilets
tonlets73212503_tonlets
trets55928023_t_r_ets
tsarists857303tsarists
turrets73010673_turrets
valets93715623_va_lets
varlet9423503_varlet_
wallets103914833_wallets
warless104015103_warless

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 Filter1786911461620.423422437.4
2DLD Change Limit1461623257.53019410.6
3Display Results3253250.1262579.4
 (SQL Overall)1786913258.07922118.0
 
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.