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

102 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
canvased1424622(None) 
canvaser13276561canvaser
canvases13349521canvases
canvassed15274041canvassed
canaled103615562can_aled
canvas113813332canvas__
canvasers14265362canvasers
canvass12376872canvas_s
canvasser14274262canvasser
canvasses14286042canvasses
abased96514993_a_based
advised12136043_advised
aneared8512743_aneared
anlases72514903_anlases
ansated84214003_ansated
anviled1138953_anviled
arrased8149863_arrased
bandaged1337313bandaged
banjaxed2542353banjaxed
cabbaged1644383cabbaged
caddised13315893caddised
caftaned1445093caftaned
callused1135853callused
calved125215453calv__ed
camases114216343ca_mases
campused1535253campused
canalised12810913canalised
canalled1139583canalled
canape10913513can_ape_
canapes111213083can_apes
canard9314763can_a_rd
canasta938363can_asta
canceled13279403canceled
cancered132411553cancered
candied113816023can_died
candled113815743can_dled
caned85838093can___ed
cankered153010223cankered
cannas84518403cannas__
canned95022063can__ned
cannoned11118143cannoned
canoed94618963can__oed
canonised1256713canonised
canopied1336343canopied
canted94825783can__ted
cantered113415983cantered
cantoned111411523cantoned
canulated12310673canulated
canvasing1546433canvasing
canvassers15273583canvassers
capiases1239253capiases
caravaned1544993caravaned
carcase11312743carcase_
carcases12313093carcases
caressed1139163caressed
caroused1149253caroused
carved124320853carv__ed
cascaded14135703cascaded
casease939323casease_
caseases10410473caseases
caseated11310713caseated
cased86032413c___ased
caucused1344093caucused
caudated1238063caudated
caused95117043ca__used
caveated1439133caveated
caved116227563ca_v__ed
caviled1348723ca_viled
ceased94920783c__eased
censed94016323cen__sed
censused11184973censused
chased125019293c__hased
concaved1636223concaved
confused1437033confused
congaed11399743conga_ed
contused1138443contused
convened143412223convened
conversed1538683conversed
conveyed17247923conveyed
convoked18236163convoked
convoyed17225553convoyed
convulsed1544383convulsed
creased104315583c_reased
crevassed1543203crevassed
cuneated11310103cuneated
cyanosed1444613cyan_osed
encased103512313_encased
fantasied1395613fantasied
hangared1337573hangared
incased103612393_incased
invaded12127043_invaded
lanated8313203lan_ated
managed113212603man_aged
mandated12310293mandated
pancaked1734893pancaked
ravaged1236493ra_vaged
salvaged1335363salvaged
sandaled1039243sandaled
savaged1236993sa_vaged
scandaled1344663scandaled
unbased103513483_unbased
uncased104216953_uncased

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.513348325.5
2DLD Change Limit1461621028.39017421.0
3Display Results1021020.0333090.9
 (SQL Overall)1786911028.93619996.8
 
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.