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

354 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
startles8211196(None) 
startle72511121startle_
startled9208561startled
startler8248791startler
startlers9236741startlers
dartles84014132_dartles
smarties10312872smarties
sparkles143210492sparkles
spurtles1037782spurtles
stabiles10311402stabiles
stables93219072sta_bles
stactes91914632stact_es
staddles10258692staddles
staithes1138952staithes
stales65538292sta__les
staples93617212sta_ples
starches131912912starches
stares66038752star__es
starless81610842star_less
starlet71620122star_let
starlets81610082star_lets
started84217322start_ed
starter73817882start_er
starters83714782starters
starts65423122start__s
startups1033892startups
starves104614552star_ves
states64337082sta_t_es
statues74614902sta_tues
tartlet72218482_tartlet
tartlets8289662_tartlets
tattles73616282_tattles
turtles72914342_turtles
argles75218483__argles
arles56735743__ar_les
artels66216233__artels
artless73712513__artless
battles94517683_battles
brattles10199333brattles
cantles94721413_cantles
carles85435083_car_les
cartels94618123_cartels
cartes86239473_cart_es
castles94917733_castles
chartless1435703chartless
chortles133611323chortles
darkles124011933_darkles
dartle73714833_dartle_
dartled9409853_dartled
ecartes94212563ecart_es
escaroles1145283escaroles
estates74520183esta_t_es
farles96025783_far_les
fartlek1434493_fartlek
fartleks1533963_fartleks
garbles104016923_garbles
gargles94214893_gargles
hantles104117513_hantles
hearties11315423hearties
heartless1236393heartless
hurtles103913753_hurtles
kirtles11309663_kirtles
mantles94820703_mantles
marbles114516653_marbles
martlet93419153_martlet
martlets103310483_martlets
myrtles1235733_myrtles
parles86334413_par_les
paroles95025893_paroles
parties93230873_parties
partlet92720363_partlet
partlets102811523_partlets
prattles10189413prattles
quartes163314943quart_es
quartiles1845613quartiles
quartzes2645463quartzes
rattles73217303_rattles
sables85026693s_a_bles
saddles95415743s_addles
safroles1136933safroles
sales56055593s_a__les
salties73725773s_alties
saltless8259343s_altless
samples112815453s_amples
sarapes94617753s_arapes
sarees65329943s_ar_ees
sarges75128593s_ar_ges
sarodes84216143s_arodes
saroses73619333s_aroses
sartors7314973s_artors
sates54949323s_a_t_es
sautes63924913s_aut_es
scabbles14167983scabbles
scales84529313sca__les
scanties103215423scanties
scares85033003scar__es
scarless10189053scar_less
scarlet91516943scar_let
scarlets10178573scar_lets
scarted104816123scart_ed
scarts85321493scart__s
scarves124511623scar_ves
scathes124515713sca_thes
scuttles1056503scuttles
searches132112903searches
seatless83213003sea_tless
settles73916003s_ettles
shackles173010593shackles
shales94731253sha__les
shambles15159043shambles
shanties113116593shanties
shares95236413shar__es
sharpies13411233sharpies
shirtless12266413shirtless
shorties11414583shorties
shuttles1136553shuttles
shvartzes2442103shvartzes
skates104219403ska_t_es
skatoles1236143skatoles
skirtless13254423skirtless
skittles1245763skittles
slates64934063sla_t_es
smartass1044273smartass
smarted105012613smart_ed
smarten9348863smart_en
smartens10286663smartens
smarter94113133smart_er
smartest10310183smart_est
smartie9310173smartie_
smartly12497433smartl_y
smartness1136143smartness
smarts86218003smart__s
snaffles14246043snaffles
snares65329033snar__es
snarled83612363snar_led
snarler73610633snar_ler
snarlers8298753snar_lers
snarls64016873snar_l_s
snathes104816493sna_thes
sorties74126403s_orties
spackles16319953spackles
spaetzles2042153spaetzles
spales84728103spa__les
spangles1138893spangles
sparables13167173sparables
spares84834553spar__es
sparges104016343spar_ges
sparkle133710213sparkle_
sparkled15317733sparkled
sparkler14317983sparkler
sparklers15315643sparklers
sparklet143110593sparklet
sparklets15275843sparklets
spates85028173spa_t_es
spathes125116533spa_thes
spatzles1935303spatzles
spittles1038333spittles
sporules1037703sporules
sprattles1174883sprattles
spurtle937453spurtle_
stabile9312063stabile_
stable83921643sta_ble_
stabled103514953sta_bled
stabler94014933sta_bler
stablers103611153sta_blers
stablest103312943sta_blest
stackless1555933stackless
stacte82113913stact_e_
staddle9288093staddle_
stades74626243sta__des
stages75629493sta__ges
staggies101210323staggies
stainless9176503stainless
stairless9185623stairless
staithe1037723staithe_
stakes103927293sta__kes
stale55637103sta__le_
staled74728103sta__led
staler64025823sta__ler
stalest73720173sta__lest
stalkless1333723stalkless
stalks104614553sta__lks
stalled83515693sta_lled
stalls64019933sta__lls
stammels12495563stammels
stampless1334543stampless
stances93715963sta_nces
stanches132312793stanches
standees93310143standees
stanes64933403sta__nes
stanines85115673stanines
stanols739733stanol_s
stapedes11197753stapedes
stapes85028733sta__pes
staple84415823sta_ple_
stapled103613703sta_pled
stapler93913633sta_pler
staplers103111203sta_plers
starched14199313starched
stardoms1136793stardoms
stare54440263star__e_
stared75429873star__ed
starer64027363star__er
starers74522313star_ers
starets73515923star_ets
stargazes1944083stargazes
starker114114693star_ker
starkers123712393starkers
starkest1239723star_kest
starkly14277033starkl_y
starkness1335963starkness
starlit71512913star_lit
starnose8136693starnose
starnoses9157153starnoses
starred85013453star_red
starrier8279463starrier
starriest9159773starriest
stars55836573star___s
start55642313start___
starting93116173starting
startling1037373startling
startsy10536703start_sy
startup934963start_up
starve94613743star_ve_
starved114911573star_ved
starver104611993star_ver
starvers11459643starvers
stases64225563sta__ses
stashes103916173sta_shes
state56237333sta_t_e_
stated75427833sta_t_ed
stateless937563stateless
stately10310223sta_tely
stater64427563sta_t_er
staters73922343sta_ters
statices102712343statices
statics93314533sta_tics
statins73719773sta_tins
statives112710793statives
stators73915583sta_tors
stats55933363sta_t__s
statue66015323sta_tue_
statued8459893sta_tued
statures83711113statures
status65515213sta_t_us
statuses8409543statuses
statutes8368893statutes
staves94525193sta__ves
stearates939453stearates
stearines9311283stearines
steeples1038013steeples
steles63725663st__eles
steres63929533ster__es
sterile7316603sterile_
sterlet71318473ster_let
sterlets8169273ster_lets
sterols7313443sterol_s
stertors8310933stertors
stickles142512103stickles
stifles103013393st_ifles
stiles64328773st__iles
stipples1247023stipples
stipules1037053stipules
stirpes95011293stir_pes
stoles63927673st__oles
stopples1236953stopples
storables1146283storables
storages9311103storages
storaxes1536883storaxes
stores65533663stor__es
stories7324273stor_ies
straddles11216403straddles
strafes104516003st_rafes
straggles11328503straggles
strakes114218073st_rakes
stranges94516763stranges
strangles103011563strangles
strapless1135793strapless
strasses81311443strasses
stratas73013583strat_as
straths102711723strat_hs
stratous8410703stratous
stratums10266813stratums
stratus73011733strat_us
streels73811343st_reels
strides84520393st_rides
strifes104716583st_rifes
strikes114719093st_rikes
stripes95320573st_ripes
strives104119373st_rives
strobes93813263st_robes
strokes114316323st_rokes
strolls739183st_rolls
stubbles1236843stubbles
stumbles1237493stumbles
sturdies92110273sturdies
sturts63915143sturt__s
styles94418653st__yles
styraxes1833493styraxes
styrenes11116623styrenes
subrules1039723subrules
svarajes1843513svarajes
swaddles13296453swaddles
swales93920763swa__les
swarajes1843743swarajes
swarths13537323swart_hs
swartness1236113swartness
swathes134115513swa_thes
tables84524893_ta_bles
tackles133816523_tackles
tactless10288463_tactless
tailles72516473_tailles
tales55451373_ta__les
tamales93216153_tamales
tangles83920053_tangles
tardies84225863_tardies
tares57456563_tar__es
targes74524603_tar_ges
tarres64723043_tar_res
tarries73324263_tarries
tartans72615823_tartans
tartars73313403_tartars
tarted74923373_tart_ed
tarter64023563_tart_er
tartest72517533_tart_est
tartier74123263_tartier
tartiest82718313_tartiest
tartly96014023_tartl_y
tartness82210133_tartness
tarts57242023_tart__s
tartufes1164153_tartufes
tastes64126423_tast_es
tates55444983_ta_t_es
tatties74120343_tatties
tattle64115653_tattle_
tattled84311483_tattled
tattler73112213_tattler
tattlers8369693_tattlers
titles63719923_t_itles
tittles73413253_tittles
tootles72915603_tootles
tortes64826053_tort_es
turtle63213573_turtle_
turtled8309683_turtled
turtler72610323_turtler
turtlers8258203_turtlers
twattles1154383twattles
warbles123215563_warbles
warsles103413643_warsles
warstles11368803_warstles
wartless11279923_wartless
wattles103814073_wattles
whortles14306743whortles
wrastles11328933wrastles

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.420425454.8
2DLD Change Limit1461623547.92318447.8
3Display Results3543540.1402528.6
 (SQL Overall)1786913548.48321064.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.