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

162 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
twaddles1331572(None) 
swaddles13296451swaddles
twaddle12245711twaddle_
twaddled14254621twaddled
twaddler13314641twaddler
twaddlers14343611twaddlers
twiddles13265611twiddles
waddles124314841_waddles
addles84216602__addles
daddles104213802_daddles
paddles113515632_paddles
raddles93615702_raddles
saddles95415742_saddles
staddles10258692staddles
straddles11216402straddles
swaddle12276742swaddle_
swaddled14254962swaddled
toddles93211532t_oddles
treddles1036262treddles
twangles1245742twangles
twattles1154382twattles
tweedles1234112tweedles
twiddle12305482twiddle_
twiddled14284632twiddled
twiddler13244872twiddler
twiddlers14313692twiddlers
waddies124214752_waddies
waddle114715302_waddle_
waddled133611642_waddled
waddler124010792_waddler
waddlers13298332_waddlers
widdles123514342_widdles
addle74318353__addle_
addled94112513__addled
awardees1243993awardees
baddies114017873_baddies
beadles103414723bea_dles
buddles113913073_buddles
caddies113718383_caddies
candles104422343_candles
caudles103912813_caudles
coddles114213593_coddles
cradles103114123cra_dles
cuddles114014093_cuddles
daddies103414943_daddies
daddle94214283_daddle_
daddled113810743_daddled
dandles94218533_dandles
dawdles12379163_dawdles
diddles103915073_diddles
dwindles13366023dwindles
fiddles123212603_fiddles
fuddles123611933_fuddles
griddles1145753griddles
handles114020653_handles
heddles123311623_heddles
huddles123712573_huddles
laddies93715053_laddies
ladles74619543_la_dles
meddles113213253_meddles
middles113415303_middles
muddles112914353_muddles
noddles92911293_noddles
paddies113715723_paddies
paddle104615143_paddle_
paddled123612023_paddled
paddler113711553_paddler
paddlers12329153_paddlers
padles95221113_pa_dles
peddles112913693_peddles
piddles114314273_piddles
puddles113613823_puddles
raddle84816173_raddle_
raddled103812223_raddled
reddles93315773_reddles
resaddles11114683resaddles
riddles93215023_riddles
ruddles92813873_ruddles
saddle83915493_saddle_
saddled103112033_saddled
saddler93811963_saddler
saddlers10289753_saddlers
spraddles13194283spraddles
staddle9288093staddle_
straddle10186223straddle_
straddled12205023straddled
straddler11205103straddler
straddlers12203813straddlers
swales93920763swa__les
swindles12319503swindles
tables84524883t_a_bles
tackles133816523t_ackles
tadpoles1135953t_adpoles
tailles72516463t_ailles
tales55451373t_a__les
tamales93216143t_amales
tangles83920043t_angles
tardies84225863t_ardies
tattles73616283t_attles
tawdries12136083tawdries
teazles16308913tea_zles
teddies92711283t_eddies
tiddler93110003t_iddler
tiddlers10288653t_iddlers
toadies82914853toa_dies
toadless936303toa_dless
toddies93011993t_oddies
toddle85811033t_oddle_
toddled10328823t_oddled
toddler9379043t_oddler
toddlers10346953t_oddlers
trachles13311753trachles
trades75724493tra_d_es
traduces1136553traduces
tramples122610203tramples
treadles939693treadles
treddle936433treddle_
treddled1134473treddled
trindles93211683trindles
trundles9278473trundles
tsades74310993tsa_d_es
twaddling1552713twaddling
twaes86513663twa___es
twangle1145803twangle_
twangled1364173twangled
twangler1244113twangler
twanglers1363433twanglers
twankies1535893twankies
twasomes1344333twasomes
twattle1064273twattle_
twattled1273463twattled
tweedle1134193tweedle_
tweedled1332833tweedled
twiddlier1441863twiddlier
twiddliest1542023twiddliest
twiddly15233773twiddl_y
twinkles1535073twinkles
unsaddles1143413unsaddles
wabbles144013993_wabbles
wadded124014173_wadd_ed
wadder114215483_wadd_er
wadders123812443_wadders
waddie114013323_waddie_
waddied13358563_waddied
waddly14478723_waddl_y
wades95634143_wa_d_es
wadies105121203_wa_dies
wadmels1334303_wadmels
waffles16329983_waffles
waggles123812003_waggles
wales86142833_wa__les
wambles143714023_wambles
wandle105316663_wandle_
wangles113416933_wangles
warbles123215563_warbles
wardless12249303_wardless
warsles103413643_warsles
wattles103814073_wattles
widdies123514033_widdies
widdle113814843_widdle_
widdled133511233_widdled
windles113518493_windles

Search took 9 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.1731032896.0
2DLD Change Limit1461621628.62316950.2
3Display Results1621620.0632571.4
 (SQL Overall)1786911628.85920170.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.