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 “canonry” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

140 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
canonry123592(None) 
cannonry1343291cannonry
calory11312842calo_ry
canary11314692can_ary
cannery123610012cannery
canny105817692can_n_y
canoer85121072canoer_
canoers94318372canoers
canon74725302canon__
canonic11312932canonic
canons85522062canon_s
canopy1337722cano_py
masonry1244122masonry
agony96415653_agon_y
almonry12104733almonry
angary10311323_angary
angry9310863_an_gry
annoy869713_an_noy
anomy105113393_ano_my
anon46134853_anon__
anonym1136383_anonym
atony87218853_aton_y
baloney1237483baloney
barony115915303baron_y
blazonry2242163blazonry
caconym1644953caconym
caconymy2042773caconymy
cadency1545893cadency
cairny11557823cairn_y
cajolery20253573cajolery
cajon144513903cajon__
cajones163311333cajones
calvary1537183calvary
camorra11115763camorra
canard9314763can_ard
cancer104220923cancer_
cancers114018583cancers
candor94516423candor_
candors104216763candors
candour104210243candour_
candours11408643candours
candy115119823ca__ndy
caner75334773can_er_
caners84629203can_ers
canine83826703canin_e
canines93724033canines
caning94128623canin_g
caninity1338063caninity
canker124422523canker_
cankers134418753cankers
canna75919333can_n_a
cannas84518403can_nas
canned95022063can_ned
cannel84216403can_nel
canner84625983can_ner
canners93822663canners
cannie83819363can_nie
cannily1239263cannily
cannoli937263cannoli
cannon84514443can_non
cannoned11118143cannoned
cannons94412883cannons
cannot83616773can_not
canoe75627253cano__e
canoed94618963cano_ed
canoes84725883cano_es
canola8313623cano_la
canolas9313993canolas
canoness1039393canoness
canonise10511093canonise
canonist10513533canonist
canonize1959833canonize
canonries1148413canonries
canopic1338803canopic
canter85230113canter_
canters94827733canters
canton85722993canton__
cantonal1038903cantonal
cantoned111411523cantoned
cantons95221203canton_s
cantor85621523cantor_
cantors94620753cantors
canty105226803ca__nty
canyon114512033canyon__
canyons124511593canyon_s
canzona1836073canzon_a
canzonas1935383canzonas
canzone1858813canzon_e
canzones1939153canzones
canzonet19410583canzonet
canzoni1836153canzon_i
capon95221873capon__
capons104119503capon_s
carney115315703ca_rney
carny105822923ca_rn_y
carry105823783ca__rry
catenary1346583catenary
cattery123811603cattery
cautery12349593cautery
cavalry1554963cavalry
cavort11316173cavo_rt
century1237193century
chancery18366653chancery
chantry15388223chan_try
cindery13429193cindery
colony115417273colon_y
coney105932883c__oney
conky145818743c__onky
cony96537833c__on_y
corny106023273c__orny
coronary1347693coronary
cory96941513c__o_ry
cowry135512483c__owry
cranny114210273cran_n_y
crony105918673c_ron_y
deaconry1443323deaconry
falconry1642533falconry
fanny114816043fan_n_y
fanon84619013fanon__
fanons96115213fanon_s
felonry13294843felonry
gantry103810113gan_try
heronry1346043heronry
laniary1068013laniary
manor78023933mano_r_
manors84420883mano_rs
manuary1237773manuary
nanny84813813nan_n_y
panfry14456413pan_fry
panoply1434713panoply
pantry115014103pan_try
savory124310563savo_ry
savoury13365873savoury
saxony1636233saxon_y
tannery10388663tannery
tannoy958353tan_noy
vapory14398763vapo_ry
vapoury15284803vapoury
wantonly1443063wantonly
weaponry1642023weaponry

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.406440125.6
2DLD Change Limit1340271407.29618369.9
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.74823062.9
 
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.