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

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

85 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
wheel11551533(None) 
heel75034221_heel
weel75834081w_eel
wheal115716181wheal
whee105429591whee_
wheels123811711wheels
wheen115016051wheen
wheep136214351wheep
cheek145115712cheek
cheep125416502cheep
cheer105420382cheer
chiel104918972chiel
creel75121482creel
eel37946842__eel
enwheel1343402enwheel
feel75233842_feel
ghee85726112ghee_
ghees95215552ghees
heal75645692_heal
heed86437602_heed
heels85625532_heels
heil76328932_heil
hell75637892_hell
herl75834552_herl
keel85729462_keel
kneel95012032kneel
peel65535612_peel
reel45240532_reel
reheel93610822reheel
seel45042982_seel
sheal84927702sheal
sheen85023312sheen
sheep105321522sheep
sheer84726892sheer
sheet84836952sheet
shekel1338382shekel
shell84424122shell
sheol84318362sheol
sheqel1846522sheqel
shiel811023772shiel
speel74420762speel
steel55721992steel
teel46335802_teel
thee78039062thee_
weal75838682w_eal
wedel94513952wedel
wee66760812w_ee_
weed85637512w_eed
week116428152w_eek
ween75835462w_een
weep95131652w_eep
weer75535092w_eer
wees76249122w_ees
weet75254152w_eet
well75832042w_ell
whale115517432whale
wheals124512522wheals
wheat114924572wheat
wheedle1434822wheedle
wheeled14318462wheeled
wheeler13298772wheeler
wheelie1336192wheelie
wheens124610612wheens
wheeple1534852wheeple
wheeps14439952wheeps
wheeze21276812wheeze
wheezy24244522wheezy
whelk154311062whelk
whelm134611982whelm
whelp136012092whelp
when105723042wh_en
whens114618762whens
where117019422where
wheres125917432wheres
whet105133782wh_et
whets115019612whets
whew137618782wh_ew
whews145114492whews
whey135018712wh_ey
wheyey1834322wheyey
wheys145911552wheys
while115418692while
whirl114913822whirl
whole114418092whole
whorl114612452whorl

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit53800851.67332157.8
3Display Results85850.0165312.5
 (SQL Overall)178691851.782100275.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.