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

112 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
canopied133634(None) 
canopies12311851canopies
candied113816022can_died
canoed94618962cano__ed
canonised1256712canonised
canonized2147682canonized
canopic1338802canopi_c
copied114618562c__opied
panoplied1443412panoplied
adopted1136253_adopted
anodized1946463_anodized
anomie83215963_anomie_
anomies93316993_anomies
anopia83412393_anopi_a
anopias92412483_anopias
atopies92816433_atopies
bandied114414303ban_died
caboched1844043caboched
caboshed1634393caboshed
caddied123710563ca_ddied
cajoled17428283cajo_led
calorie92716903calorie_
calories102919563calories
calorized21249673calorized
camped134720233ca_mp_ed
campier133313273ca_mpier
canaled103615563can_aled
canalised12810913canalised
canalized21611693canalized
canalled1139583canalled
canape10913513canap_e_
canapes111213083canap_es
canaries10318943canaries
canceled13279403canceled
cancered132411553cancered
candid104517853can_di_d
candies104125613can_dies
candled113815743can_dled
caned85838093can___ed
canfield1444333can_field
canid85526343can__i_d
canities101519263canities
cankered153010223cankered
canned95022063can__ned
cannie83819363can_nie_
cannier94014163can_nier
cannoned11118143cannoned
canoe75627253cano__e_
canoeing11310213canoeing
canoeist10310693canoeist
canoer85121073cano__er
canoes84725883cano__es
canonic11312933canoni_c
canonise10511093canonise
canonises11410803canonises
canonist10513533canonist
canonize1959833canonize
canonizer2046693canonizer
canonizes2049593canonizes
canonries1148413canonries
canoodled1342803canoodled
canopy1337723canop__y
canopying1745063canopying
canted94825783can__ted
cantered113415983cantered
cantoned111411523cantoned
canvased14246223canvased
caped104931803ca__p_ed
caponier1237883caponier
caponized2347073caponized
capped134721853ca__pped
carhopped1972763carhopped
caried94528693ca__ried
carnified1547293carnified
caroled103717693caro_led
carolled1138833carolled
caromed123713623caro_med
carotid102014833caroti_d
caroused1149253caroused
carped115923763ca_rp_ed
carried103717153ca_rried
casefied1445943casefied
catnapped1692503catnapped
cavitied14126813cavitied
cavorted1435693cavorted
chopped174511003c_hopped
clopped143611523c_lopped
conoid9818883cono_i_d
conspired1445663conspired
cooped114821603c_oop_ed
coopted123710763c_oopted
coped105036843c__op_ed
copier103722893c__opier
copies104130303c__opies
copped135221253c__opped
cosied94819883c__osied
cozied184112153c__ozied
crannied1137893cran_nied
cropped143812063c_ropped
cyanosed1444613cyano_sed
fancied133310603fan_cied
galoped11138083galop_ed
ganoid8314443gano_i_d
jalopies1786673jalopies
knopped16355453_knopped
pandied113913443pan_died
panfried14134933panfried
panoplies1346003panoplies
parodied1238333parodied
recopied1339843recopied
sinopie948783sinopie_
vanitied12138213vanitied

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.546327272.9
2DLD Change Limit1461621127.59619242.0
3Display Results1121120.0462434.8
 (SQL Overall)1786911128.18821823.5
 
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.