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

136 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
covaried144800(None) 
covaries13413251covaries
caried94528692c__aried
chivaried1844052chivaried
covered133315292cover_ed
ovaries10312652_ovaries
unvaried1239682unvaried
varied104817862__varied
boarded113910503bo_arded
bogarted1235053bogarted
calvaries1449803calvaries
canaries10318943canaries
carded105424903c__arded
cared86050093c__ar_ed
caries85147623c__aries
carked134024823c__arked
carped115923763c__arped
carried103717153c_arried
carted98631443c__arted
carved124320853c__arved
cavalier1348183cavalier
cavalries1446363cavalries
caverned1436163caverned
cavitied14126813cavitied
cavorted1435693cavorted
chaired134211243c_haired
chared125423693c_har_ed
charged144614023c_harged
charier124317903c_harier
charked174814013c_harked
charmed154714253c_harmed
charred134614483c_harred
charted135116853c_harted
chivareed1843123chivareed
chivaries1757433chivaries
claries93422203c_laries
cleared103612463clear_ed
clovered14187363clover_ed
coached153313843co_ached
coacted123611613co_acted
coaled95022713co_a_led
coalier93416183co_alier
coapted123911503co_apted
coarse84813903co_arse_
coarsen93210323co_arsen
coarser93211203co_arser
coasted104015953co_asted
coated94927043co_a_ted
coaxed165612513co_a_xed
cochaired1743883cochaired
coderived1644793coderived
codified1537403codified
coerced1238583co_erced
cohabited1744023cohabited
cohered133514693coher_ed
collared113211143collar_ed
collied103316673co_llied
colored10313473color_ed
colorized212211773colorized
companied1648023companied
compared153811823compar_ed
comparted16338423comparted
complied1539673complied
comprised1648053comprised
comprized2567223comprized
contrived1547993contrived
converged1636973converged
conversed1538683conversed
converted15311563converted
copied114618563co__pied
corded105923353co__rded
cored85044223co__r_ed
corked135020783co__rked
corned95224523co__rned
corraded12128293corraded
corrie83621223co_rrie_
corries94026793co_rries
cosied94819883co__sied
costarred1244703costarred
coterie9417403coterie_
coteries10422703coteries
courier93617893co_urier
coursed104113603co_ursed
courted103514923co_urted
covariant1447863covariant
covariate1446213covariate
covariates1545783covariates
covary1438743covar__y
covarying1844133covarying
coved115027373cov___ed
coverer123113523cover_er
covering142215723covering
coverlet13413013coverlet
coverlid1445943coverlid
coveted133011523cov_eted
coward12411673cowar__d
cowered133214653cower_ed
cowrie113814283co_wrie_
cowries124218013co_wries
cozied184112153co__zied
cried84624283c___ried
curarized2176403curarized
curried103313653c_urried
governed1335193governed
hoarded12368343ho_arded
hoarier104211743ho_arier
hovered143411573hover_ed
liveried1238733liveried
notaries8314933notaries
notarized1947153notarized
oared65030653_o_ar_ed
ovarial1037613_ovarial
ovarian1037643_ovarian
overbed132811853_overbed
overed102216623_over_ed
overfed142510253_overfed
polarised1269233polarised
polarized21610283polarized
roared75015393ro_ar_ed
rosaries8312783rosaries
rotaries8315693rotaries
safaried1236253safaried
salaried9311023salaried
soared74324293so_ar_ed
solarised1068043solarised
solarized1969153solarized
toadied9248013to_adied
tovarich1643453tovarich
tovarish1445123tovarish
varier94619353__varier
varies94330873__varies
varved134110603__varved
vivaries1439263vivaries
votaries11312013votaries
wearied112911803_wearied
worried11308693wo_rried

Search took 7 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.423422437.4
2DLD Change Limit1461621366.36022981.4
3Display Results1361360.0462956.5
 (SQL Overall)1786911366.82926166.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.