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

105 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
wheeple153485(None) 
wheedle1434821wheedle
wheepled1733291wheepled
wheeples1634741wheeples
steeple937322steeple
weepie11258792w_eepie
wheedled1633032wheedled
wheedler1543542wheedler
wheedles1534642wheedles
wheel115515332whee_l_
wheeled14318462whee_led
wheeler13298772whee_ler
wheelie1336192wheelie
wheels123811712whee_ls
wheep136214352wheep__
wheeped16387502wheeped
wheeps14439952wheep_s
wheeze21276812whee_ze
beetle8311673_beetle
cheapie1437563cheapie
cheaply1735023cheaply
cheep125416503cheep__
cheeped153410593cheeped
cheeper143610743cheeper
cheeps135312913cheep_s
cheerled14105703cheerled
cheerly15417603cheerly
cheese113812763chee_se
creepie1137483creepie
deeply1257013_deeply
feeble1138253_feeble
heckle153112093_heckle
heddle114211163_heddle
heel75034223_hee_l_
heeled104018413_hee_led
heeler93917313_hee_ler
heels85625533_hee_ls
heeze175313483_hee_ze
hempie132410563_hempie
hirple11158973_hirple
hopple132910483_hopple
needle73310613_needle
people10310193_people
semple103212753_semple
sheenie10159493sheenie
sheep105321523sheep__
sheepmen1544643sheepmen
sheerly13337703sheerly
sheeve123412843shee_ve
steepled1135893steepled
steeples1038013steeples
steeply1236293steeply
teepee8314363_teepee
temple102811333_temple
tweedle1134193tweedle
veepee11311483_veepee
weekly1635313w_eekly
weel75834083w_ee_l_
weenie92612023w_eenie
weep95131653w_eep__
weeper114313303w_eeper
weepier12319273w_eepier
weepies122811743w_eepies
weeps104120563w_eep_s
weepy134212593w_eep_y
weewee12310083w_eewee
whale115517433wh__ale
wheal115716183wh_eal_
wheals124512523wh_eals
whee105429593wh_e__e
wheedlers1643193wheedlers
wheelers14287733whee_lers
wheelies1437863wheelies
wheelless1543763wheelless
wheelmen1643313wheelmen
wheen115016053whee__n
wheens124610613whee_ns
wheeping17337103wheeping
wheepling1843323wheepling
wheezed23296453wheezed
wheezer22296673wheezer
wheezes22306803wheezes
wheezier2333343wheezier
wheezily2642303wheezily
wheezy24244523whee_zy
whelk154311063wh_e_lk
whelm134611983wh_e_lm
whelp136012093wh_e_lp
whelped16355633whelped
whelpless1742053whelpless
whelps14437843whelp_s
whence14187923wh_ence
where117019423wh_e_re
wherve15568113wh_erve
whiffle1933533whiffle
while115418693wh__ile
whistle13107533whistle
whittle13106103whittle
whole114418093wh__ole
whoopee15287513whoopee
whoopie15295933whoopie
whoopla1542633whoopla
whortle13335943whortle
wimple133611363w_imple
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.406440125.6
2DLD Change Limit1340271056.33021173.3
3Display Results1051050.0303500.0
 (SQL Overall)1786911056.76626410.1
 
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.