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

203 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
treddles103626(None) 
reddles93315771_reddles
treadles939701treadles
treddle936431treddle_
treddled1134471treddled
griddles1145752griddles
heddles123311622_heddles
meddles113213252_meddles
peddles112913702_peddles
raddles93615702_raddles
reddle83815912_reddle_
reddled102912322_reddled
riddles93215022_riddles
ruddles92813872_ruddles
straddles11216402straddles
teddies92711282t_eddies
toddles93211532t_oddles
treacles1039702treacles
treadle8310102treadle_
treadled1067122treadled
treadler936862treadler
treadlers1045892treadlers
treadless1036002treadless
trebles9311442tre_bles
trembles1237352trembles
trendies9312212trendies
trestles83012552trestles
trindles93211682trindles
trundles9278482trundles
twaddles13315722twaddles
tweedles1234112tweedles
twiddles13265612twiddles
addles84216603__addles
aediles83413903_aediles
areoles71016953are_oles
beadles103414733_beadles
breadless1235943breadless
bredes94818473bre_d_es
bridles104114473br_idles
brindles113710223brindles
buddles113913073_buddles
coddles114213593_coddles
cradles103114133cr_adles
creoles9913323cre_oles
cuddles114014093_cuddles
daddles104213803_daddles
diddles103915073_diddles
dredges10379343dre_dges
dreidels1033213dreidels
dreidls934053dreidl_s
eddies83313163__eddies
eddoes8199143__eddoes
ediles74016983__ediles
fiddles123212603_fiddles
freckles17126383freckles
fuddles123611933_fuddles
greedless1144893greedless
griddle1035503griddle_
griddled1244203griddled
heddle114211163_heddle_
huddles123712573_huddles
meddle103312763_meddle_
meddled123210033_meddled
meddler11319953_meddler
meddlers12318203_meddlers
middles113415303_middles
muddles112914353_muddles
neddies92710703_neddies
needles83211563_needles
noddles92911293_noddles
oreides8312023oreid_es
paddles113515643_paddles
peddle103512823_peddle_
peddled123410533_peddled
peddler113210493_peddler
peddlers12298533_peddlers
piddles114314273_piddles
predates11615813predates
predries112714383predries
prefiles133113443prefiles
presales10315263presales
puddles113613823_puddles
raddle84816173_raddle_
raddled103812223_raddled
readies83324713_readies
reales64934123_re_ales
redates83423873_redates
redded94019543_redd_ed
redden83613613_redd_en
reddens9259783_reddens
redder83918133_redd_er
redders93615343_redders
reddest9311953_redd_est
redds74617833_redd__s
redes65139123_re_d_es
redeyes112910973_redeyes
redleg839263_re_dleg
redlegs936823_re_dlegs
redoes74623753_re_does
redoxes15310883_redoxes
redries83721713_redries
reduces10513343_reduces
redyes104214083_re_dyes
refiles104122423_refiles
regales83520793_regales
resaddles11114693_resaddles
resales74724903_resales
resiles74026543_resiles
resoles73823653_resoles
retiles74426993_retiles
reviles104421353_reviles
riddle83915713_riddle_
riddled103012043_riddled
riddler93411263_riddler
riddlers10269103_riddlers
ruddle83414203_ruddle_
ruddled103010873_ruddled
rundles83214713_rundles
saddles95415743_saddles
spraddles13194283spraddles
staddles10258693staddles
straddle10186223straddle_
straddled12205023straddled
straddler11205113straddler
straddlers12203823straddlers
swaddles13296453swaddles
teazles16308923t_eazles
tedded93810893t_edd_ed
tedder83312153t_edd_er
tedders94010233t_edders
teles54536003t_e__les
temples112610893t_emples
teredines1049453teredines
threadless1442473threadless
tiddler93110003t_iddler
tiddlers10288653t_iddlers
toddies93011993t_oddies
toddle85811033t_oddle_
toddled10328823t_oddled
toddler9379043t_oddler
toddlers10346963t_oddlers
trachles13311753trachles
trades75724503tr_ad_es
traduces1136563traduces
tramples122610203tramples
treacle939973treacle_
treaded95014283tread_ed
treader84113833tread_er
treaders93311843treaders
treads74817923tread__s
treaties8316983treaties
treble8311663tre_ble_
trebled1038483tre_bled
treddling1234423treddling
treeless839283tre_eless
trees55835763tre___es
trehalas1144883trehalas
trellis739873tre_llis
tremble1138003tremble_
trembled1335253trembled
trembler1235363trembler
tremblers1334483tremblers
tremolos1046043tremolos
trenches133512603trenches
trended94011763trend_ed
trendier937913trendier
trendiest1038423trendiest
trends75513543trend__s
tressels8367653tressels
tresses73719543tre_sses
trestle72611363trestle_
trickles143013763trickles
trifles103814823tr_ifles
trindle83311363trindle_
trindled10388693trindled
triodes84012503triod_es
triples94616873tr_iples
trodden934883trodd_en
troubles1057203troubles
truckles14319383truckles
trudges9339993tr_udges
truffles1485593truffles
trundle8307873trundle_
trundled10306393trundled
trundler9256153trundler
trundlers10215003trundlers
twaddle12245713twaddle_
twaddled14254623twaddled
twaddler13314643twaddler
twaddlers14343613twaddlers
tweedle1134193tweedle_
tweedled1332833tweedled
twiddle12305483twiddle_
twiddled14284633twiddled
twiddler13244873twiddler
twiddlers14313693twiddlers
unriddles1143503unriddles
ureides8311103ureid_es
urodeles945563urodeles
waddles124314843_waddles
wheedles1534643wheedles
widdles123514343_widdles
wrestles113310063wrestles

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.1561145455.1
2DLD Change Limit1461622037.25020160.3
3Display Results2032030.0802537.5
 (SQL Overall)1786912037.48623870.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.