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

55 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
lyceums144240(None) 
lyceum1343951lyceum_
locums10478302loc_ums
lycees11428862lyce_es
alyssums1341963alyssums
chums125015833__chums
clypeus1433243clypeu_s
dictums1235553dictums
eyecups1442823eyecups
fyces139813643fyce__s
geums85414113__geums
gypsums1541923gypsums
labrums1175853labrums
lacers85225253lace_rs
laces76141763lace__s
lactams1136953lactams
larums83610533l_arums
leuds66214813l__euds
lieus56218483l_ieu_s
lineups934913lineups
linums838283l_inums
lockups1534243lockups
locum94812173loc_um_
locus74819993loc_u_s
lucerns935753lucerns
luces75528433luce__s
lums65734243l___ums
luteum837783luteum_
lycea10418943lyce__a
lycee104716743lyce__e
lychees15516783lychees
lyches144213613lyc_hes
lychnis1544383lychnis
lycras11287253lyc_ras
lyes75530833ly_e__s
lyres85019963lyre__s
lyrisms1235653lyrisms
lyses84518253lyse__s
museums1134563museums
myceles1435213myceles
neums75414253__neums
odeums9367313_odeums
oleums8358783_oleums
rectums11338523rectums
rheums1135463_rheums
sacrums11388043sacrums
scrums104614253_scrums
scums95017423_sc_ums
sycees11409653syce_es
syces106416463syce__s
tectums11306423tectums
vacuums1443403vacuums
xylems1833203xyle_ms
yeuks125110093_y_euks
ylems1039263_yle_ms

Search took 6 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.1561145455.1
2DLD Change Limit134027555.67323625.4
3Display Results55550.0163437.5
 (SQL Overall)178691555.84530571.6
 
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.