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 “wheeplee” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

46 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
wheeple1534871wheepl_e
wheepled1733301wheepled
wheeples1634751wheeples
wheedle1434832wheedl_e
wheedled1633042wheedled
wheedler1543552wheedler
wheedles1534652wheedles
wheeled14318472whee_led
wheeler13298782whee_ler
wheelie1336202whee_lie
wheeped16387512wheep_ed
cheeped153410593cheep_ed
cheeper143610743cheep_er
cheerled14105713cheerled
heeled104018423_hee_led
heeler93917323_hee_ler
sheepmen1544643sheepmen
steeple937323steepl_e
steepled1135903steepled
steeples1038013steeples
teepee8314363_teep_ee
veepee11311483_veep_ee
weeper114313303w_eep_er
weepie11258793w_eep_ie
weepier12319273w_eepier
weepies122811743w_eepies
weewee12310093w_ee_wee
wheedlers1643203wheedlers
wheel115515343whee_l__
wheelers14287743whee_lers
wheelies1437873wheelies
wheelless1543773wheelless
wheelmen1643323wheelmen
wheels123811723whee_l_s
wheep136214353wheep___
wheeping17337103wheeping
wheepling1843323wheepling
wheeps14439953wheep__s
wheeze21276823whee__ze
wheezed23296463whee_zed
wheezer22296683whee_zer
wheezes22306813whee_zes
wheezier2333353wheezier
whelped16355643whelp_ed
whelpless1742053whelpless
whoopee15287523whoop_ee

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.453394461.4
2DLD Change Limit146162467.48619524.7
3Display Results46460.0133538.5
 (SQL Overall)178691467.95222471.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.