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

291 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
startled920856(None) 
started84217321start_ed
startle72511121startle_
startler8248791startler
startles82111961startles
dartled9409852_dartled
scarted104816122scart_ed
smarted105012612smart_ed
snarled83612362snar_led
sparkled15317732sparkled
stabled103514952sta_bled
staled74728102sta__led
stalled83515692sta_lled
stapled103613702sta_pled
starched14199312starched
stared75429872star__ed
starlet71620122star_let
starred85013452star_red
starter73817882start_er
startlers9236742startlers
starved114911572star_ved
stated75427832sta_t_ed
statued8459892sta_tued
tarted74923372_tart_ed
tartlet72218482_tartlet
tattled84311482_tattled
turtled8309682_turtled
argled85314553__argled
ariled75620323__ariled
battled104213123_battled
brattled11196723brattled
caroled103717693_caroled
carted98631443_cart_ed
castled104311513_castled
charted135116853chart_ed
chortled14326613chortled
darkled13378723_darkled
darted84620923_dart_ed
dartle73714833_dartle_
dartles84014133_dartles
earthed1139923_earthed
estated83715573esta_t_ed
farted105121783_fart_ed
fartlek1434493_fartlek
garbled114512803_garbled
gargled104210673_gargled
gnarled9287723gnar_led
hearted113314033heart_ed
hurtled11339593_hurtled
kirtled12287033_kirtled
mantled104113393_mantled
marbled123212113_marbled
marled95523163_mar_led
marted94425213_mart_ed
martlet93419153_martlet
parled94626293_par_led
paroled104217633_paroled
parted94228683_part_ed
partied103516553_partied
partlet92720363_partlet
pearled10411553pear_led
prattled11246533prattled
rattled84012953_rattled
restarted10410053restart_ed
saddled103112033s_addled
sailed74327763s_a_iled
salted74121203s_alt_ed
sampled123410793s_ampled
sated66238533s_a_t_ed
sauted74119603s_aut_ed
sauteed8349613s_auteed
scabbled15156303scabbled
scaled94822443sca__led
scanted104114393scant_ed
scared95227293scar__ed
scarfed134711183scar_fed
scarlet91516943scar_let
scarped124314403scar_ped
scarphed1635443scarphed
scarred104512633scar_red
scathed134012643sca_thed
scatted103512773sca_tted
scrawled1445923scrawled
scuttled1134533scuttled
sealed74328363sea__led
searched14209253searched
seared75232843sear__ed
seated75131063sea_t_ed
settled83210873s_ettled
shackled18277603shackled
shafted14288813shaft_ed
shaled105023953sha__led
shambled16156153shambled
shared105829063shar__ed
sharked153613913shar_ked
sharped134112053shar_ped
shauled1148793sha_uled
shawled1437773sha_wled
shorted113614403short_ed
shuttled1234673shuttled
skated114414883ska_t_ed
skirled12348183skir_led
skirted12388613skirt_ed
slanted83514743slant_ed
slated75028313sla_t_ed
slatted84015183sla_tted
smarten9348863smart_en
smartened1244273smartened
smarter94113133smart_er
smartie9310173smartie_
smarties10312873smarties
smartly12497433smartl_y
smartweed1542113smartweed
snaffled15285213snaffled
snailed83811923sna_iled
snared74824553snar__ed
snarfed11378753snar_fed
snarler73610633snar_ler
snorted83813493snort_ed
soared74324293soar__ed
sorted74523713s_ort_ed
sortied83314103s_ortied
spackled17297803spackled
spalled103113133spa_lled
spangled1236153spangled
spared95427493spar__ed
sparged113512763spar_ged
sparked143513143spar_ked
sparkle133710213sparkle_
sparkler14317983sparkler
sparkles143210493sparkles
sparklet143110593sparklet
sparred104512863spar_red
spathed134013183spa_thed
spatted104014143spa_tted
spiraled1137733spiraled
spirted103913073spirt_ed
sported104015433sport_ed
sprattled1263313sprattled
sprawled1434523sprawled
spurted103111973spurt_ed
spurtle937453spurtle_
spurtles1037783spurtles
stabbed123510373sta_bbed
stabile9312063stabile_
stabiles10311403stabiles
stable83921643sta_ble_
stabler94014933sta_bler
stables93219073sta_bles
stacked143416123sta_cked
stacte82113913stact_e_
stactes91914633stact_es
staddle9288093staddle_
staddles10258693staddles
staffed14298283sta_ffed
staged84521563sta__ged
stagged104212083sta_gged
stained84215343sta_ined
staithe1037723staithe_
staithes1138953staithes
staked114621943sta__ked
stale55637103sta__le_
staler64025823sta__ler
stales65538293sta__les
stalked123811173sta_lked
stamened1137633stamened
stamped124812813sta_mped
stanched14208903stanched
staned74824643sta__ned
stanged94113853sta_nged
stanzaed1843873stanzaed
staple84415823sta_ple_
stapler93913643sta_pler
staples93617213sta_ples
starches131912913starches
stare54440263star__e_
starer64027363star__er
stares66038753star__es
stargazed2043073stargazed
starker114114693star_ker
starkly14277033starkl_y
starless81610843star_less
starlets81610083star_lets
starlit71512913star_lit
starrier8279463starrier
start55642313start___
starters83714783starters
starting93116173starting
startling1037373startling
starts65423123start__s
startsy10536703start_sy
startup934963start_up
startups1033893startups
starve94613743star_ve_
starver104611993star_ver
starves104614553star_ves
stashed113812493sta_shed
state56237333sta_t_e_
stately10310223sta_tely
stater64427563sta_t_er
states64337083sta_t_es
statue66015323sta_tue_
statues74614903sta_tues
staved103918053sta__ved
stayed104817273sta__yed
steeled83513223st_eeled
steepled1135903steepled
stereoed937883stereoed
sterile7316603sterile_
sterlet71318473ster_let
stetted82610403st_etted
stickled15298973stickled
stifled113511093st_ifled
stilled83314793st_illed
stilted83511473stilt_ed
stinted82914193stint_ed
stippled1345303stippled
stipuled1134453stipuled
stirred8359703stir_red
stoled74521593st__oled
stooled84313893st_ooled
stoppled1345003stoppled
stored75524213stor__ed
storeyed1234643storeyed
storied8515163stor_ied
stormed1039043stor_med
stotted83511423st_otted
straddled12205023straddled
strafed114413333st_rafed
straggled12296853straggled
strained9412253strained
straked125415343st_raked
stranded102710813stranded
strangled11268983strangled
strapped1357823strapped
strawed114813623st_rawed
strayed114513283st_rayed
streeled9267873streeled
strewed115811343st_rewed
striped105214363st_riped
strived114713663st_rived
stroked124613623st_roked
strolled937823strolled
strowed115312143st_rowed
stroyed114110863st_royed
strutted946343strutted
stubbled1385073stubbled
stumbled1335623stumbled
stunted83010403stunt_ed
sturdied10215963sturdied
styled105613103st__yled
swaddled14254963swaddled
swarded1238153swar_ded
swarmed1367483swar_med
swathed144611933swa_thed
swatted114110693swa_tted
swirled11308223swir_led
tabled94020043_ta_bled
tackled143913193_tackled
tailed74424663_ta_iled
tangled94214643_tangled
tared69340053_tar__ed
tarred74720283_tar_red
tarried83914133_tarried
tarter64023563_tart_er
tartier74123263_tartier
tartlets8289663_tartlets
tartly96014023_tartl_y
tarweed1137343_tarweed
tasted74123973_tast_ed
tatted74920533_ta_tted
tattle64115653_tattle_
tattler73112213_tattler
tattles73616283_tattles
tauted75317113_taut_ed
tirled74714363_tir_led
titled73815003_t_itled
tootled83511043_tootled
trailed83415673_trailed
trawled113411523_trawled
turtle63213573_turtle_
turtler72610323_turtler
turtles72914343_turtles
twattled1273463twattled
upstarted1244213upstart_ed
warbled133212163_warbled
warsled112910443_warsled
warstled12286123_warstled
warted104223233_wart_ed
wattled113610503_wattled
wrastled12346433wrastled

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.423422437.4
2DLD Change Limit1461622917.37319824.0
3Display Results2912910.1102645.5
 (SQL Overall)1786912917.90622601.9
 
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.