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

103 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
wheeples163474(None) 
wheedles1534641wheedles
wheeple1534851wheeple_
wheepled1733291wheepled
steeples1038012steeples
weepies122811742w_eepies
wheedle1434822wheedle_
wheedled1633032wheedled
wheedler1543542wheedler
wheedlers1643192wheedlers
wheeled14318462whee_led
wheeler13298772whee_ler
wheelers14287732whee_lers
wheelies1437862wheelies
wheelless1543762wheelless
wheels123811712whee_l_s
wheeped16387502wheep_ed
wheeps14439952wheep__s
wheezes22306802whee_zes
whelpless1742052whelpless
beetles9312083_beetles
cheapies1539033cheapies
cheekless1873883cheekless
cheeped153410593cheep_ed
cheeper143610743cheep_er
cheepers15329013cheepers
cheeps135312913cheep__s
cheerled14105703cheerled
cheerless1495293cheerless
cheeses123613103chee_ses
creepies1239613creepies
heckles163711383_heckles
heddles123311623_heddles
heedless12278813_heedless
heeled104018413_hee_led
heeler93917313_hee_ler
heelers103815623_hee_lers
heelless11257653_heelless
heels85625533_hee_l_s
heezes184211643_hee_zes
helpless1335063_helpless
herpes115517323_herp_es
hirples12149643_hirples
hopples142810713_hopples
needles83211563_needles
peoples11312223_peoples
sheenies111411543sheenies
sheepmen1544643sheepmen
sheerlegs1343293sheerlegs
sheetless1235823sheetless
sheeves133911953shee_ves
sleepless1144553sleepless
steeple937323steeple_
steepled1135893steepled
teepees939263_teepees
temples112610893_temples
tweedles1234113tweedles
veepees1245813_veepees
weedless12287963w_eedless
weeklies1534913w_eeklies
weenies102915093w_eenies
weeper114313303w_eep_er
weepers123511973w_eepers
weepie11258793w_eepie_
weepier12319273w_eepier
weepiest13219473w_eepiest
weeps104120563w_eep__s
weewees1336563w_eewees
whales124716943wh__ales
wheals124512523wh_eal_s
wheatless1534003wheatless
wheel115515333whee_l__
wheelie1336193whee_lie
wheelmen1643313wheelmen
wheens124610613whee__ns
wheep136214353wheep___
wheeping17337103wheeping
wheepling1843323wheepling
wheeze21276813whee_ze_
wheezed23296453whee_zed
wheezer22296673whee_zer
wheezers23265273wheezers
wheezier2333343wheezier
wheeziest2443663wheeziest
whelks16367323wh_e_lks
whelms14377573wh_e_lms
whelped16355633whelp_ed
whelps14437843wh_e_lps
whereases1545673whereases
wheres125917433wh_e_res
wherries14179023wherries
wherves16548053wh_erves
whiffles2034263whiffles
whiles124418013wh__iles
whistles14108213whistles
whittles1496673whittles
wholes124616773wh__oles
whoopees16294823whoopees
whoopies16267373whoopies
whooplas1644013whooplas
whortles14306743whortles
wimples143311173w_imples
wrestles113310063wrestles

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621036.00024360.3
3Display Results1031030.0502060.0
 (SQL Overall)1786911036.47027618.4
 
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.