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

163 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
canneries1131307(None) 
tanneries9310421tanneries
canaries10318942ca_naries
canners93822662canner__s
cannonries1244092cannonries
canonries1148412canonries
catteries11815512catteries
causeries11510632causeries
cauteries11615362cauteries
chanceries1747642chanceries
congeries12316392congeries
gunneries1047042gunneries
henneries1248642henneries
nunneries947102nunneries
swanneries1344362swanneries
aeries64737783_a__eries
amberies122514673_amberies
anergies9310453_a_nergies
angaries9314383_angaries
ankerites1348523_ankerites
annelids946233_annelids
annexes1437203_anne_xes
anserines9411283_anserines
aperies9423203_a_peries
arteries8321463_arteries
bakeries14312193ba_keries
bannered11299323banner_ed
banneret102412473banner_et
bannerets11205463bannerets
bannering12208803bannering
bannerols1144093bannerols
banners94018713banner__s
batteries11615113batteries
beaneries11310903beaneries
binderies12311663binderies
cabinetries1544083cabinetries
cachexies2364163cachexies
cadencies1447323cadencies
cajoleries1944753cajoleries
calories102919543ca_lories
calvaries1449803calvaries
cancered132411553cancer_ed
cancerous1367523cancerous
cancers114018583cancer__s
candies104125613ca_n_dies
caners84629193ca_ner__s
caninities12410463caninities
canities101519243ca_nities
cankered153010223canker_ed
cankering162110793cankering
cankerous1566043cankerous
cankers134418753canker__s
cannabins1365783cannabins
cannabis1266033cannabi_s
cannabises1444433cannabises
cannelons1145213cannelons
cannels93413363canne__ls
canner84625983canner___
cannery123610003canner__y
cannie83819363cann__ie_
cannier94014163cann__ier
canniest10313363cann__iest
cannikins15225683cannikins
cannolis1037863cannoli_s
canoers94318373canoer__s
canonesses1238413canonesses
canopies12311853ca_nopies
cantered113415983canter_ed
cantering122417373cantering
canters94827723canter__s
cantrips12318923ca_ntrips
caries85147623ca___ries
carnies94123963carn__ies
carnifies1439893carnifies
carries94328013ca__rries
casefies1339213ca_sefies
casernes103810753ca_sernes
catenaries1248663catenaries
causerie1078263causerie_
cauterizes2197993cauterizes
cavalries1446363cavalries
celeries10316313c_eleries
centuries11311333centuries
chandleries1744313chandleries
channelizes2552993channelizes
chantries14310273chantries
cinerins10414093c_inerins
clowneries1544733clowneries
coannexes1843643coanne_xes
conferees14610623conferees
conners94023113conner__s
conniveries1644703conniveries
conserves14311183conserves
converges1538373converges
converses14311163converses
cookeries151210633cookeries
cooperies131113313cooperies
coteries10422703c_oteries
countries11313593countries
cranberries1554243cranberries
crannies10313013crann__ies
cunners93913463cunner__s
cutleries1179213cutleries
cycleries1647033cycleries
dauberies1248023dauberies
deaneries10310833deaneries
eateries8324303ea_teries
faeries104118993fa__eries
fakeries1559833fa_keries
fanners103914653fanner__s
fannies103415643fann__ies
ferneries1239033ferneries
fineries112416743_fineries
flaneries1249563flaneries
galleries10311703galleries
gantries91413783ga_ntries
gauderies1147743gauderies
gauntries1046033gauntries
innerves1158013_innerves
jaggeries18136973jaggeries
japeries17311463ja_peries
joineries1648103joineries
knaveries1645013knaveries
laniaries9411213laniaries
lanneret82512353lanner_et
lannerets9225483lannerets
lanners73618323lanner__s
laundries1045563laundries
lingeries10511803lingeries
mannered11249653manner_ed
mannerism1355943mannerism
mannerisms1455003mannerisms
mannerist1149093mannerist
mannerists1245923mannerists
mannerless1243523mannerless
manners93417833manner__s
masteries111018493masteries
monkeries15129903monkeries
nannies73015203nann__ies
naperies10313903na_peries
orangeries11116943orangeries
panfries13149203pa_nfries
panners93621273panner__s
pantries101817393pa_ntries
pineries102419083_pineries
sanserifs1244653sanserifs
santerias9311833santerias
scanners10379703scanner__s
sceneries1149393sceneries
shinneries1345713shinneries
spinneries1245733spinneries
stannaries1045763stannaries
tangerines1147533tangerines
tanners74018393tanner__s
turneries948493turneries
unnerves1157273_unnerves
vanners103612843vanner__s
veneries112815023_veneries
vineries112716043_vineries
waggeries14127463waggeries
wannesses1239233wannesses
wasteries121115343wasteries
wineries112316533_wineries

Search took 10 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.1701051123.5
2DLD Change Limit1486411639.37615853.3
3Display Results1631630.1401164.3
 (SQL Overall)1786911639.68618448.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.