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

52 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
glabrous114553(None) 
glamorous1245092glamorous
glaucous1144222glaucous
globous1036492glob_ous
scabrous1245992scabrous
aurous64119263__aurous
clamorous1346193clamorous
claroes93113733cla_roes
claros84015113cla_ro_s
cribrous1246003cribrous
cumbrous1446173cumbrous
elytrous1145503elytrous
fibrous1237593_fibrous
flavorous1544253flavorous
frabjous2042623frabjous
gabbros12124653gabbro_s
gabions102410053g_abions
gaboons10289893g_aboons
gallous82813953g_allous
garrons82713463g_arrons
gaseous839503g_aseous
generous939763generous
gibbous1265333g_ibbous
glabrate1146033glabrate
gladiolus11112943gladiolus
glaires84010133glair_es
glairs75211333glair__s
glamors1068113gla_mors
glamour1065133gla_mour
glamourous1352353glamourous
glamours1184723gla_mours
glares75518863gla_r_es
glorious946823glorious
goitrous945763goitrous
gracious1138593gracious
laborious1144763_laborious
labors84016403_lab_ors
labour84210933_lab_our
labours9349883_lab_ours
labrets939363_labrets
labroid1038823_labroid
labroids1155833_labroids
labrum1057423_labr_um
labrums1175853_labrums
ladrons83813193_ladrons
leprous938843_leprous
parous84024163_pa_rous
scabious1246593scabious
slumbrous1343973slumbrous
sombrous1246603sombrous
ulcerous1046163ulcerous
valorous1147373valorous

Search took 9 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.203880251.2
2DLD Change Limit146162528.39317414.8
3Display Results52520.0301733.3
 (SQL Overall)178691528.62620715.4
 
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.