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

47 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
eyewear134262(None) 
eyebar1135322eye_bar
eyebeam1443562eyebeam
rewear93012002_rewear
beweary1536223_beweary
brewer114812553brewe_r
chewer145512623chewe_r
dewar95817733_dew_ar
dyeweed1543203dyeweed
emeer74815363eme_e_r
endear74110013e_ndear
evener91010623evene_r
ewer77523983__ewe_r
eyebars1245333eye_bars
eyebeams1542133eyebeams
eyeless1058053eyeless
eyelet9514533eyele_t
eyelets1057523eyelets
eyer76127283ey__e_r
eyewash1642583eyewash
eyewater1444243eyewater
eyewink1743193eyewink
fewer115216123_fewe_r
hewer115719933_hewe_r
menswear1352183menswear
neckwear1741393neckwear
newer85717463_newe_r
outwear1097713outwear
overwear14248603overwear
prewar114712583prew_ar
redear73515173_redear
regear73512743_regear
rehear93713223_rehear
renewer10248693renewe_r
retear63115483_retear
rewears102911043_rewears
sewar85421103_sew_ar
sewer84426223_sewe_r
shewer124515113shewe_r
skewer13519613skewe_r
skiwear1442523skiwear
spewer115112153spewe_r
swear85316853__swear
unswear1035003unswear
viewer1237213viewe_r
wear75836723___wear
year76534253_y__ear

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 Filter1786911340270.420425454.8
2DLD Change Limit134027477.03319056.9
3Display Results47470.0301566.7
 (SQL Overall)178691477.48323879.6
 
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.