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

96 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
straddle1018622(None) 
astraddle1142871astraddle
spraddle12194161spraddle
staddle9288091st_addle
straddled12205021straddled
straddler11205111straddler
straddles11216401straddles
raddle84816172__raddle
saddle83915492s__addle
spraddled14203462spraddled
spraddles13194282spraddles
staddles10258692st_addles
straddlers12203822straddlers
straggle10359132straggle
strangle98411502strangle
swaddle12276742s_waddle
treddle936432_treddle
twaddle12245712_twaddle
addle74318353___addle
cradle93313163_cra_dle
daddle94214283__daddle
griddle1035503_griddle
paddle104615143__paddle
raddled103812223__raddled
raddles93615703__raddles
reddle83815913__reddle
resaddle10115223resaddle
riddle83915713__riddle
ruddle83414203__ruddle
saddled103112033s__addled
saddler93811963s__addler
saddles95415743s__addles
scrabble14196993scrabble
scramble14177253scramble
scrapple1434683scrapple
skedaddle1651303skedaddle
sprattle1054763sprattle
sraddha1242083s_raddha
stabile9312063st_abile
stable83921643st_a_ble
stade64825303st_a_d_e
staidly1136683st_aidly
stale55637103st_a__le
standee83514513st_andee
staple84415823st_a_ple
startle72511123st_artle
steadily1236213steadily
storable10310733stora_ble
straddling1343643straddling
strafe95215983stra__fe
straggled12296853straggled
straggler11377293straggler
straggles11328503straggles
straggly13355563straggly
straitly1136563straitly
strake104017393stra__ke
strand74514823strand__
stranded102710813stranded
strander97112063strander
strandline1145363strandline
strands83711953strand_s
strange85416343stra_nge
strangled11268983strangled
strangler10369473strangler
strangles103011553strangles
stratal72710603stratal_
stravage1245563stravage
strickle1467793strickle
stridden1044273stridden
stride75420963str_id_e
strobile1047033strobile
strode75215973str_od_e
strudel835783strudel_
strudels934123strudels
struggle10345053struggle
studdie9195273st_uddie
swaddled14254963s_waddled
swaddles13296453s_waddles
toddle85811033_t_oddle
trachle12311853_trachle
tradable1139873_tradable
trade65026043_tra_d_e
traduce1036353_traduce
trample11299703_trample
treadle8310103_treadle
treddled1134473_treddled
treddles1036263_treddles
trindle83311363_trindle
trundle8307873_trundle
twaddled14254623_twaddled
twaddler13314643_twaddler
twaddles13315723_twaddles
twiddle12305483_twiddle
unriddle1043983unriddle
unsaddle1044753unsaddle
waddle114715303__waddle

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.406440125.6
2DLD Change Limit146162967.46619577.0
3Display Results96960.0332909.1
 (SQL Overall)178691967.90522604.8
 
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.