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

110 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
wheedle143482(None) 
wheedled1633031wheedled
wheedler1543541wheedler
wheedles1534641wheedles
wheeple1534851wheeple
heddle114211162_heddle
needle73310612_needle
tweedle1134192tweedle
wheedlers1643192wheedlers
wheel115515332whee_l_
wheeled14318462whee_led
wheeler13298772whee_ler
wheelie1336192wheelie
wheels123811712whee_ls
wheepled1733292wheepled
wheeples1634742wheeples
wheeze21276812whee_ze
beadle93314683_beadle
beetle8311673_beetle
cheerled14105703cheerled
cheerly15417603cheerly
cheese113812763chee_se
feeble1138253_feeble
handle104219293_handle
heckle153112093_heckle
heddles123311623_heddles
hedge105317333_h_edge
heed86437603_heed__
heeded114215763_heeded
heeder104216043_heeder
heedless12278813_heedless
heeds95420423_heed_s
heel75034223_hee_l_
heeled104018413_hee_led
heeler93917313_hee_ler
heels85625533_hee_ls
heeze175313483_hee_ze
hondle103914523_hondle
huddle113712993_huddle
hurdle103712793_hurdle
meddle103312763_meddle
needled9358513_needled
needler8388893_needler
needles83211563_needles
peddle103512823_peddle
reddle83815913_reddle
sheenie10159493sheenie
sheerly13337703sheerly
sheeve123412843shee_ve
steeple937323steeple
treadle8310103treadle
treddle936433treddle
tweedled1332833tweedled
tweedles1234113tweedles
waddle114715303w_addle
wandle105316663w_andle
wedel94513953w_edel_
wedeled1237783w_edeled
wedeln10326693w_edeln
wedels103811033w_edels
wedge105215633w__edge
weed85637513w_eed__
weeded113914873w_eeded
weeder103315513w_eeder
weedier113810623w_eedier
weedily1476123w_eedily
weedless12287963w_eedless
weedlike1634393w_eedlike
weeds95222213w_eed_s
weedy125115003w_eed_y
weekly1635313w_eekly
weel75834083w_ee_l_
weenie92612023w_eenie
weepie11258793w_eepie
weewee12310083w_eewee
whale115517433wh__ale
wheal115716183wh_eal_
wheals124512523wh_eals
whee105429593wh_e__e
wheedling1733073wheedling
wheelers14287733whee_lers
wheelies1437863wheelies
wheelless1543763wheelless
wheelmen1643313wheelmen
wheen115016053whee__n
wheens124610613whee_ns
wheep136214353whee__p
wheeped16387503wheeped
wheeps14439953whee_ps
wheezed23296453wheezed
wheezer22296673wheezer
wheezes22306803wheezes
wheezier2333343wheezier
wheezily2642303wheezily
wheezy24244523whee_zy
whelk154311063wh_e_lk
whelm134611983wh_e_lm
whelp136012093wh_e_lp
whence14187923wh_ence
where117019423wh_e_re
wherve15568113wh_erve
whiffle1933533whiffle
while115418693wh__ile
whistle13107533whistle
whittle13106103whittle
whole114418093wh__ole
whortle13335943whortle
widdle113814843w_iddle
windle104617953w_indle
wrestle10298843wrestle

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.1531167915.0
2DLD Change Limit1340271106.62620227.4
3Display Results1101100.0333333.3
 (SQL Overall)1786911106.81226231.8
 
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.