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

92 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
canonries114841(None) 
cannonries1244091cannonries
calories102919562calo_ries
canaries10318942can_aries
canneries11313082canneries
canonise10511092canon_ise
canonises11410802canonises
canonizes2049592canonizes
canopies12311852cano_pies
masonries1146852masonries
agonies83016623_agon_ies
almonries1156933almonries
angaries9314393_angaries
anomies93316993_ano_mies
atonies75320953_aton_ies
baronies10315023baron_ies
blazonries2153133blazonries
caconymies1953733caconymies
cadencies1447323cadencies
cajoleries1944763cajoleries
cajones163311333cajon__es
calorics122810463calo_rics
calorie92716903calo_rie_
calorizes202312303calo_rizes
calvaries1449803calvaries
candies104125613ca__ndies
canines93724033canin__es
caninities12410493caninities
canities101519263can_ities
cannie83819363can_n_ie_
cannier94014163can_n_ier
canniest10313363can_n_iest
cannolis1037863cannoli_s
cannonades13143823cannonades
canoers94318373canoer__s
canoes84725883cano___es
canoness1039393canon_ess
canonesses1238423canonesses
canonic11312933canon_i_c
canonised1256713canonised
canonist10513533canon_ist
canonists1158513canonists
canonize1959833canon_ize
canonized2147683canonized
canonizer2046693canonizer
canonizers2144413canonizers
canonry1235923canonr__y
canons85522063canon___s
canoodles1244003canoodles
canopied1336343cano_pied
canorous10310193cano_rous
cantrips12318933can_trips
canzones1939153canzon__es
caponier1237883capon_ier
caponiers1345733capon_iers
caponizes2238703caponizes
caries85147623ca___ries
carnies94123963ca_rn_ies
carries94328013ca__rries
catenaries1248663catenaries
catteries11815523catteries
causeries11510643causeries
cauteries11615393cauteries
cavalries1446363cavalries
centuries11311333centuries
chanceries1747653chanceries
chantries14310293chan_tries
colonies103620013colon_ies
congeries12316403congeries
conies84338593c__on_ies
coonties10513803c_oonties
coronaries12410233coronaries
corries94026803c__orries
cowries124218013c__owries
crannies10313013cran_n_ies
cronies9622503c_ron_ies
deaconries1345173deaconries
falconries1543963falconries
fannies103415643fan_n_ies
felonries1246203felonries
gantries91413793gan_tries
heronries1248483heronries
laniaries9411223laniaries
nannies73015203nan_n_ies
panfries13149203pan_fries
panoplies1346003panoplies
pantries101817393pan_tries
savories11311273savo_ries
savouries1245473savouries
saxonies1537913saxon_ies
tanneries9310423tanneries
weaponries1543073weaponries

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 Filter1786911486410.436409841.7
2DLD Change Limit148641926.84621712.1
3Display Results92920.0462000.0
 (SQL Overall)178691927.32824384.7
 
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.