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 “straddled” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
straddled1220502(None) 
spraddled14203461spraddled
straddle10186221straddle_
straddler11205111straddler
straddles11216401straddles
astraddle1142872astraddle_
raddled103812222__raddled
saddled103112032s__addled
spraddle12194162spraddle_
spraddles13194282spraddles
staddle9288092st_addle_
staddles10258692st_addles
straddlers12203822straddlers
straggled12296852straggled
stranded102710812strand_ed
strangled11268982strangled
swaddled14254962s_waddled
treddled1134472_treddled
twaddled14254622_twaddled
addled94112523___addled
bradded12388713_bradd_ed
cradled113410813_cra_dled
daddled113810743__daddled
griddled1244203_griddled
paddled123612023__paddled
radded94716493__radd_ed
raddle84816173__raddle_
raddles93615703__raddles
reddled102912323__reddled
resaddled1294253resaddled
riddled103012043__riddled
ruddled103010873__ruddled
saddle83915493s__addle_
saddler93811963s__addler
saddles95415743s__addles
scrabbled16154973scrabbled
scrambled16164813scrambled
scrawled1445923scra_wled
shredded1444063shredd_ed
skedaddled1851023skedaddled
sprattled1263313sprattled
sprawled1434523spra_wled
squadded2033843squadd_ed
stabled103514953st_a_bled
staled74728103st_a__led
stalled83515693st_a_lled
stapled103613703st_a_pled
startled9208563st_artled
steaded92811673stea_d_ed
steadied1036563stea_died
straddling1343643straddling
strafed114413333stra__fed
straggle10359133straggle_
straggler11377293straggler
straggles11328503straggles
strained9412253stra_ined
straked125415343stra__ked
strander97112063strand_er
strangle98411503strangle_
strangler10369473strangler
strangles103011553strangles
strapped1357823stra_pped
stravaged1444193stravaged
strawed114813613stra__wed
strayed114513283stra__yed
streeled9267873str_eeled
strickled1665833strickled
stridden1044273stridd_en
strolled937823str_olled
struggled12304303struggled
studded10236873st_udd_ed
swaddle12276743s_waddle_
swaddles13296453s_waddles
toddled10328823_t_oddled
trachled1438313_trachled
traded85717683_tra_d_ed
traduced1244673_traduced
trailed83415673_tra_iled
trameled11309073_trameled
trampled13247903_trampled
traveled12349453_traveled
trawled113411523_tra_wled
treadled1067123_treadled
treddle936433_treddle_
treddles1036263_treddles
trindled10388693_trindled
trundled10306393_trundled
twaddle12245713_twaddle_
twaddler13314643_twaddler
twaddles13315723_twaddles
twiddled14284633_twiddled
unriddled1243813unriddled
unsaddled1243983unsaddled
waddled133611643__waddled

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 Filter1786911486410.423422437.4
2DLD Change Limit148641946.56322648.3
3Display Results94940.0462043.5
 (SQL Overall)178691947.03225411.1
 
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.