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

193 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
treddle93643(None) 
reddle83815911_reddle
treadle8310101treadle
treddled1134471treddled
treddles1036261treddles
griddle1035502griddle
heddle114211162_heddle
meddle103312762_meddle
peddle103512822_peddle
raddle84816172_raddle
reddled102912322_reddled
reddles93315772_reddles
riddle83915712_riddle
ruddle83414202_ruddle
straddle10186222straddle
toddle85811032t_oddle
treacle939972treacle
treadled1067122treadled
treadler936862treadler
treadles939702treadles
treble8311662tre_ble
tremble1138002tremble
trestle72611362trestle
trindle83311362trindle
trundle8307872trundle
twaddle12245712twaddle
tweedle1134192tweedle
twiddle12305482twiddle
addle74318353__addle
aedile73716653_aedile
areole61017283are_ole
astraddle1142873astraddle
atremble1244113atremble
beadle93314683_beadle
brede85520503bre_d_e
bridle94115463br_idle
brindle104210103brindle
buddle104313083_buddle
coddle104713853_coddle
cradle93313163cr_adle
credal9311673credal_
credible1346023credible
creole8913733cre_ole
cuddle104414533_cuddle
daddle94214283_daddle
diddle94915213_diddle
dredge9308563dre_dge
dreidel934473dreidel
dreidl835233dreidl_
dreidls934053dreidls
edile64819493__edile
fiddle113613383_fiddle
freckle16106643freckle
fuddle113312103_fuddle
griddled1244203griddled
griddles1145753griddles
heddles123311623_heddles
huddle113712993_huddle
meddled123210033_meddled
meddler11319953_meddler
meddles113213253_meddles
middle103414983_middle
muddle103414633_muddle
needle73310613_needle
noddle83211363_noddle
oreide7311673oreid_e
paddle104615143_paddle
peddled123410543_peddled
peddler113210493_peddler
peddles112913703_peddles
piddle103514913_piddle
predate10616893predate
predive13511083predive
prefile123413183prefile
presale9416353presale
puddle103914153_puddle
raddled103812223_raddled
raddles93615703_raddles
redate74124683_redate
redd66323173_redd__
redded94019553_redded
redden83613623_redden
redder83918143_redder
redds74617833_redd_s
rede55037673_re_d_e
redeye103811793_redeye
rediae74221993_rediae
redleg839273_re_dleg
redly94217203_re_dly
redone74820053_redone
reduce9713253_reduce
redye94413473_re_dye
refile95122373_refile
regale74821453_regale
resaddle10115223_resaddle
resale64025543_resale
resile64627673_resile
resole64624183_resole
retile65929673_retile
revile94921613_revile
riddled103012043_riddled
riddler93411263_riddler
riddles93215023_riddles
ruddled103010873_ruddled
ruddles92813873_ruddles
rundle73214233_rundle
saddle83915493_saddle
sedile73517233_sedile
spraddle12194163spraddle
staddle9288093staddle
straddled12205023straddled
straddler11205113straddler
straddles11216403straddles
swaddle12276743swaddle
teazle15329553t_eazle
tedded93810903t_edded
tedder83312163t_edder
teddies92711283t_eddies
teddy10489493t_edd_y
tele45040873t_e__le
temple102811333t_emple
tiddler93110003t_iddler
tiddly11308783t_iddly
tiredly1136803tire_dly
toddled10328823t_oddled
toddler9379043t_oddler
toddles93211533t_oddles
trachle12311853trachle
tradable1139873tradable
trade65026043tr_ad_e
traduce1036353traduce
trample11299703trample
treacles1039703treacles
treacly1237093treacly
tread64821703tread__
treaded95014283treaded
treader84113833treader
treadlers1045893treadlers
treadless1036003treadless
treads74817923tread_s
trebled1038483tre_bled
trebles9311443tre_bles
trebly1138973tre_bly
treddling1234423treddling
tree47745813tre___e
treed65626733treed__
trehala1045953trehala
trembled1335253trembled
trembler1235363trembler
trembles1237353trembles
trembly1435523trembly
tremolo946513tremolo
trend64817453trend__
trended94011763trended
trendier937913trendier
trendies9312213trendies
trendily1256443trendily
trends75513543trend_s
trendy10469603trend_y
tressel73010893tressel
trestles83012553trestles
triable92515393triable
trickle133613443trickle
trifle94012883tr_ifle
trindled10388693trindled
trindles93211683trindles
triode75311893triod_e
triple84215923tr_iple
trodden934883trodden
trode65322853tr_od_e
trouble957713trouble
truckle13358863truckle
trudge8318733tr_udge
truffle1384893truffle
trundled10306393trundled
trundler9256153trundler
trundles9278483trundles
twaddled14254623twaddled
twaddler13314643twaddler
twaddles13315723twaddles
tweedled1332833tweedled
tweedles1234113tweedles
twiddled14284633twiddled
twiddler13244873twiddler
twiddles13265613twiddles
twiddly15233773twiddly
unriddle1043983unriddle
ureide7310363ureid_e
urodele845963urodele
waddle114715303_waddle
wheedle1434823wheedle
widdle113814843_widdle
wrestle10298843wrestle

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271936.75019855.9
3Display Results1931930.0762539.5
 (SQL Overall)1786911937.23224708.4
 
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.