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

115 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
wheedles153464(None) 
wheedle1434821wheedle_
wheedled1633031wheedled
wheedler1543541wheedler
wheedlers1643191wheedlers
wheeples1634741wheeples
heddles123311622_heddles
heedless12278812_heedless
needles83211562_needles
tweedles1234112tweedles
weedless12287962w_eedless
wheeled14318462whee_led
wheeler13298772whee_ler
wheelers14287732whee_lers
wheelies1437862wheelies
wheelless1543762wheelless
wheels123811712whee_l_s
wheeple1534852wheeple_
wheepled1733292wheepled
wheezes22306802whee_zes
beadles103414733_beadles
beedies10314203_beedies
beetles9312083_beetles
cheekless1873883cheekless
cheerled14105703cheerled
cheerless1495293cheerless
cheeses123613103chee_ses
deedless10318253_deedless
greedless1144893greedless
handles114020653_handles
headless12289863_headless
heckles163711383_heckles
heddle114211163_heddle_
hedges115016263_h_edges
heeded114215763_heed_ed
heeder104216043_heed_er
heeders114213743_heeders
heeds95420423_heed__s
heeled104018413_hee_led
heeler93917313_hee_ler
heelers103815623_hee_lers
heelless11257653_heelless
heels85625533_hee_l_s
heezes184211643_hee_zes
heredes11313133_hered_es
hondles113614523_hondles
huddles123712573_huddles
hurdles113613373_hurdles
meddles113213253_meddles
needle73310613_needle_
needled9358513_needled
needler8388893_needler
needlers9287423_needlers
needless9308333_needless
peddles112913703_peddles
reddles93315773_reddles
seedless9319513_seedless
sheenies111411543sheenies
sheerlegs1343293sheerlegs
sheetless1235823sheetless
sheeves133911953shee_ves
steeples1038013steeples
treadles939703treadles
treddles1036263treddles
tweedle1134193tweedle_
tweedled1332833tweedled
waddles124314843w_addles
wedeled1237783w_edeled
wedelns11325243w_edelns
wedels103811033w_edel_s
wedges114614583w__edges
weeded113914873w_eed_ed
weeder103315513w_eed_er
weeders113412933w_eeders
weedier113810623w_eedier
weediest122311133w_eediest
weeds95222213w_eed__s
weeklies1534913w_eeklies
weenies102915093w_eenies
weepies122811743w_eepies
weewees1336563w_eewees
weldless12285813w_eldless
whales124716943wh__ales
wheals124512523wh_eal_s
wheatless1534003wheatless
wheedling1733073wheedling
wheel115515333whee_l__
wheelie1336193whee_lie
wheelmen1643313wheelmen
wheens124610613whee__ns
wheeped16387503whee_ped
wheeps14439953whee__ps
wheeze21276813whee_ze_
wheezed23296453whee_zed
wheezer22296673whee_zer
wheezers23265273wheezers
wheezier2333343wheezier
wheeziest2443663wheeziest
whelks16367323wh_e_lks
whelms14377573wh_e_lms
whelpless1742053whelpless
whelps14437843wh_e_lps
whereases1545673whereases
wheres125917433wh_e_res
wherries14179023wherries
wherves16548053wh_erves
whiffles2034263whiffles
whiles124418013wh__iles
whistles14108213whistles
whittles1496673whittles
wholes124616773wh__oles
whortles14306743whortles
widdles123514343w_iddles
windles113518493w_indles
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.420425454.8
2DLD Change Limit1461621157.47019566.5
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.93622516.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.