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

152 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
twaddle1224571(None) 
swaddle12276741swaddle
twaddled14254621twaddled
twaddler13314641twaddler
twaddles13315721twaddles
twiddle12305481twiddle
waddle114715301_waddle
addle74318352__addle
daddle94214282_daddle
paddle104615142_paddle
raddle84816172_raddle
saddle83915492_saddle
staddle9288092staddle
straddle10186222straddle
swaddled14254962swaddled
swaddles13296452swaddles
toddle85811032t_oddle
treddle936432treddle
twaddlers14343612twaddlers
twangle1145802twangle
twattle1064272twattle
tweedle1134192tweedle
twiddled14284632twiddled
twiddler13244872twiddler
twiddles13265612twiddles
twiddly15233772twiddly
waddie114013322_waddie
waddled133611642_waddled
waddler124010792_waddler
waddles124314842_waddles
waddly14478722_waddly
wandle105316662_wandle
widdle113814842_widdle
addled94112523__addled
addles84216603__addles
astraddle1142873astraddle
awardee1137563awardee
baddie104114033_baddie
beadle93314683bea_dle
buddle104313083_buddle
caddie104316453_caddie
candle94321483_candle
caudle93912913_caudle
coddle104713853_coddle
cradle93313163cra_dle
cuddle104414533_cuddle
daddled113810743_daddled
daddles104213803_daddles
dandle84218093_dandle
dawdle11399503_dawdle
diddle94915213_diddle
dwindle12415883dwindle
fiddle113613383_fiddle
fuddle113312103_fuddle
griddle1035503griddle
handle104219293_handle
heddle114211163_heddle
huddle113712993_huddle
laddie83713173_laddie
ladle66320443_la_dle
meddle103312763_meddle
middle103414983_middle
muddle103414633_muddle
noddle83211363_noddle
paddled123612023_paddled
paddler113711553_paddler
paddles113515643_paddles
padle84522343_pa_dle
peddle103512823_peddle
piddle103514913_piddle
puddle103914153_puddle
raddled103812223_raddled
raddles93615703_raddles
reddle83815913_reddle
resaddle10115223resaddle
riddle83915713_riddle
ruddle83414203_ruddle
saddled103112033_saddled
saddler93811963_saddler
saddles95415743_saddles
spraddle12194163spraddle
staddles10258693staddles
straddled12205023straddled
straddler11205113straddler
straddles11216403straddles
swale85221593swa__le
swindle11389183swindle
table75429603t_a_ble
tackle123815733t_ackle
tadpole1036143t_adpole
taille63116923t_aille
tale46154163t_a__le
tamale83717403t_amale
tangle74019953t_angle
tattle64115653t_attle
teazle15329553tea_zle
tiddler93110003t_iddler
tiddly11308783t_iddly
toddled10328823t_oddled
toddler9379043t_oddler
toddles93211533t_oddles
towable121910113towa_ble
towardly1543653towardly
trachle12311853trachle
tradable1139873tradable
trade65026043tra_d_e
traduce1036353traduce
trample11299703trample
treadle8310103treadle
treddled1134473treddled
treddles1036263treddles
trindle83311363trindle
trundle8307873trundle
tsaddik1342073tsaddik
tsade64311123tsa_d_e
twaddling1552713twaddling
twae74719573twa___e
twangled1364173twangled
twangler1244113twangler
twangles1245743twangles
twasome1244623twasome
twattled1273463twattled
twattles1154383twattles
tweedled1332833tweedled
tweedles1234113tweedles
twiddlers14313693twiddlers
twiddlier1441863twiddlier
twinkle1464773twinkle
tzaddik2241763tzaddik
unsaddle1044753unsaddle
wabble133714843_wabble
wadable13310233_wadable
wadded124014173_wadded
wadder114215483_wadder
waddied13358563_waddied
waddies124214753_waddies
waddlers13298333_waddlers
waddy135312993_wadd_y
wade85237063_wa_d_e
wadmel1235523_wadmel
waffle15369183_waffle
waggle113612303_waggle
wale74546433_wa__le
wamble134415753_wamble
wangle103817503_wangle
warble113516603_warble
warsle93112923_warsle
wattle94314213_wattle
widdie113410733_widdie
widdled133511233_widdled
widdles123514343_widdles
windle104617953_windle

Search took 7 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.390458182.1
2DLD Change Limit1340271525.92322628.2
3Display Results1521520.0463304.3
 (SQL Overall)1786911526.35928100.5
 
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.