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

114 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
tweedles123411(None) 
tweedle1134191tweedle_
tweedled1332831tweedled
needles83211562_needles
treadles939692treadles
treddles1036262treddles
twaddles13315722twaddles
tweedier1253622tweedier
tweediest1344272tweediest
tweeds10498432tweed__s
tweenies11146392tweenies
tweezes19345702twee_zes
twiddles13265612twiddles
weedless12287962_weedless
wheedles1534642wheedles
beadles103414723_beadles
beedies10314203_beedies
beetles9312083_beetles
deedless10318253_deedless
dwindles13366023dwindles
greedless1144893greedless
heddles123311623_heddles
heedless12278813_heedless
meddles113213253_meddles
needle73310613_needle_
needled9358513_needled
needler8388893_needler
needlers9287423_needlers
needless9308333_needless
peddles112913693_peddles
reddles93315773_reddles
seedless9319513_seedless
steeples1038013steeples
swaddles13296453swaddles
swedes102711893sw_ed_es
sweenies11148763sweenies
sweeties11159723sweeties
swindles12319503swindles
teazles16308913t_eazles
teddies92711283t_eddies
teels55726373t_ee_l_s
teepees939263t_eepees
teethes103611653t_eethes
teles54536003t__e_les
temples112610893t_emples
toddles93211533t_oddles
treacles1039703treacles
treadle8310103treadle_
treadled1067123treadled
treadler936853treadler
treadlers1045883treadlers
treadless1035993treadless
trebles9311443t_rebles
treddle936433treddle_
treddled1134473treddled
treeless839283tree_less
trembles1237353trembles
trendies9312213trendies
trestles83012553trestles
trindles93211683trindles
trundles9278473trundles
tuxedoes1642743tuxedoes
twaddle12245713twaddle_
twaddled14254623twaddled
twaddler13314643twaddler
twaddlers14343613twaddlers
twangles1245743twangles
twattles1154383twattles
tweed94915093tweed___
tweediness1443173tweediness
tweedling1442533tweedling
tweedy13455933tweed__y
tweener10306833twee_ner
tweeners11306243tweeners
tweeness11246403tweeness
tweens9489843twee__ns
tweeted11336583twee_ted
tweeter10288533twee_ter
tweeters11287143tweeters
tweets94210103twee__ts
tweeze18265473twee_ze_
tweezed20274993twee_zed
tweezer19305763twee_zer
tweezers20254383tweezers
twelves1334303tw_elves
twenties1137503twenties
twiddle12305483twiddle_
twiddled14284633twiddled
twiddler13244873twiddler
twiddlers14313693twiddlers
twinkles1535073twinkles
waddles124314843_waddles
wedeled1237783_wedeled
wedelns11325243_wedelns
wedels103811033_wedel_s
wedges114614553_w_edges
weeded113914873_weed_ed
weeder103315513_weed_er
weeders113412933_weeders
weedier113810623_weedier
weediest122311133_weediest
weeds95222213_weed__s
weeklies1534913_weeklies
weenies102915093_weenies
weepies122811743_weepies
weewees1336563_weewees
weldless12285813_weldless
wheedle1434823wheedle_
wheedled1633033wheedled
wheedler1543543wheedler
wheedlers1643193wheedlers
wheeples1634743wheeples
widdles123514343_widdles
windles113518493_windles

Search took 10 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 Limit1461621149.34315644.0
3Display Results1141140.0462478.3
 (SQL Overall)1786911149.54518720.9
 
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.