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 “cycleries” 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
cycleries164703(None) 
celeries10316312c_eleries
cutleries1179212cutleries
cyclers1435872cycler__s
archeries14411223archeries
butleries11710073butleries
cachexies2364163cachexies
cajoleries1944763cajoleries
calories102919563c_alories
canneries11313083canneries
catteries11815553catteries
causeries11510643causeries
cauteries11615403cauteries
cicelies1269753cic_elies
claries93422203__claries
clergies1137903__clergies
clerics1149333__clerics
clerids1049093__clerids
collieries1248343collieries
congeries12316403congeries
cookeries151210643cookeries
cooperies131113323cooperies
coteries10422713c_oteries
crockeries1857123crockeries
cutcheries1745093cutcheries
cyclases1537133cycl_ases
cyclecars1542373cyclecars
cycler1335913cycler___
cyclery1763493cycler__y
cycles1339303cycl___es
cycleways2262203cycleways
cyclins1438303cycl__ins
cyclizes2445523cycl_izes
cyclizines2652513cyclizines
cycloids1647043cycl_oids
cyclones1537483cycl_ones
cyclonites1744913cyclonites
cyclopes1746263cycl_opes
cycloserines1952993cycloserines
cycloses1538183cycl_oses
cyclosis1547473cyclosi_s
fooleries1248743fooleries
fulleries1248723fulleries
galleries10311713galleries
helleries122611693helleries
lecheries1449073lecheries
mockeries17128263mockeries
mysteries141211193mysteries
pedleries1298783pedleries
rifleries1247693rifleries
rockeries15128973rockeries
sclerites1139443_sclerites
sculleries1244833sculleries
sealeries9313133sealeries
voleries11313233_voleries

Search took 7 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 Filter1786911486410.420425454.8
2DLD Change Limit148641556.20323962.8
3Display Results55550.0163437.5
 (SQL Overall)178691556.63926915.3
 
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.