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

202 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
canopies1231185(None) 
canopied1336341canopied
anomies93316992_anomies
anopias92412482_anopias
atopies92816432_atopies
calories102919562calories
canapes111213082canap_es
canaries10318942canaries
candies104125612can_dies
canities101519262canities
canoes84725882cano__es
canonise10511092canonise
canonises11410802canonises
canonizes2049592canonizes
canonries1148412canonries
canopic1338802canopi_c
copies104130302c__opies
jalopies1786672jalopies
panoplies1346002panoplies
acnodes1037833acno_des
agonies83016623_agonies
anodes74418763_ano_des
anodizes1837963_anodizes
anoles64827433_ano_les
anomie83215963_anomie_
anopia83412393_anopi_a
anopsias10337983_anopsias
anoxias14259113_anoxias
atomies93918363_atomies
atonies75320953_atonies
bandies104124863ban_dies
banshies131110663banshies
banties94324763ban_ties
baronies10315023baronies
cabbies133115163ca_bbies
cabooses1237863cabooses
caddies113718383ca_ddies
cajoles163712103cajo_les
cajones163311333cajo_nes
calipees1247413calipees
calorics122810463calorics
calorie92716903calorie_
calorizes202312303calorizes
calottes10610083calottes
cammies134016483ca_mmies
camomiles15155633camomiles
campier133313273ca_mpier
campiest142212143ca_mpiest
canakins142010463canakins
canalise10816213canalise
canalises11515493canalises
canalizes201113783canalizes
canape10913513canap_e_
candids113812693can_dids
candied113816023can_died
candles104422343can_dles
canes75350373can___es
cangues10611823can_gues
canids95118133can__ids
canikins14219163canikins
canines93724033can_ines
canneries11313083canneries
cannie83819363can_nie_
cannier94014163can_nier
canniest10313363can_niest
cannolis1037863cannoli_s
cannonries1244093cannonries
canoe75627253cano__e_
canoed94618963cano__ed
canoeing11310213canoeing
canoeist10310693canoeist
canoeists1147163canoeists
canoer85121073cano__er
canoers94318373cano_ers
canolas9313993cano_las
canoness1039393canoness
canonic11312933canoni_c
canonised1256713canonised
canonist10513533canonist
canonists1158513canonists
canonize1959833canonize
canonized2147683canonized
canonizer2046693canonizer
canonizers2144413canonizers
canons85522063cano__ns
canoodles1244003canoodles
canopy1337723canop__y
canopying1745063canopying
canorous10310193canorous
cantles94721413can_tles
cantrips12318933cantrips
canvases13349523canvases
canzones1939153canzones
capes95441923ca__p_es
capias10318353ca__pias
capizes20410373ca__pizes
caponier1237883caponier
caponiers1345733caponiers
caponizes2238703caponizes
capotes11314643capo_tes
caries85147623ca__ries
carnies94123963ca_rnies
carnifies1439893carnifies
carnotites1246543carnotites
caroches15710693caroches
carotids11229943carotids
carotins102315583carotins
carouses10614503carouses
carries94328013ca_rries
caryopses1645043caryopses
casefies1339213casefies
catties94023053ca_tties
cavies114525003ca__vies
cavities131412613cavities
cenobites1346203cenobites
cenotes92814543ceno_tes
chanties132615803chan_ties
chantries14310293chantries
chappies172610103chappies
cheapies1539033cheapies
chippies17309763chippies
chopines152711733c_hopines
chopins142312243c_hopins
colies84837053c__olies
colonies103620013colonies
conchies153214853conchies
conies84338593c__onies
conoids10813883cono_ids
conspires1358483conspires
cookies133719273c_ookies
coolies93824963c_oolies
coonties10513803coonties
cooties93725733c_ooties
copes97747103c__op_es
copied114618563c__opied
copier103722893c__opier
copiers114215963c__opiers
copses104922473c__opses
corodies11313693corodies
cosies84932153c__osies
cowpies143314283c_owpies
cozies174521413c__ozies
crankpins17133763crankpins
crannies10313013cran_nies
crappies142911163crappies
creepies1239613creepies
cronies9622503c_ronies
croppies143111133croppies
cyanoses1337423cyano_ses
cyanosis1346273cyanosi_s
dandies94121443dan_dies
economies1348623economies
fancies124018783fan_cies
fannies103415643fan_nies
ganoids939333gano_ids
gantries91413793gantries
hankies143617763han_kies
harpies123818323ha_rpies
jaloppies2043223jaloppies
lanolines939983lanolines
lanolins8310533lanolins
magpies12310363ma_gpies
maniples12269423maniples
manropes1237913manrop_es
manyplies1643893manyplies
monodies11312503monodies
myopies14309723_myopies
nancies93516843nan_cies
nannies73015203nan_nies
nappies114613403na_ppies
pandies104224503pan_dies
panfries13149203panfries
panoches1548123panoches
panoplied1443413panoplied
panpipes1135173pan_pipes
pansies94521983pan_sies
pansophies1774193pansophies
panties94230933pan_ties
pantries101817393pantries
pappies103214833pa_ppies
parodies11313693parodies
randies84225663ran_dies
ranpikes1435643ran_pikes
recopies12313733recopies
sandpiles1246303sandpiles
sandpits1146843sandpits
sanies63031953san__ies
sanities81219773sanities
savories11311273savories
saxonies1537913saxonies
scampies1439333sca_mpies
scanties103215423scan_ties
senopias1048823senopias
sinopias1047873sinopias
sinopie948783sinopie_
synopses1346223synopses
tansies74521243tan_sies
tawpies12309873ta_wpies
vanities111414493vanities
whoopies16267373whoopies
wicopies1545983wicopies
zanies153219673zan__ies

Search took 9 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 Filter1786911461620.403443402.0
2DLD Change Limit1461622027.50019488.3
3Display Results2022020.0802525.0
 (SQL Overall)1786912027.98322383.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.