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

240 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
covaries1341325(None) 
covaried1448001covaried
ovaries10312651_ovaries
calvaries1449802calvaries
canaries10318942canaries
caries85147622c__aries
cavalries1446362cavalries
chivaries1757432chivaries
claries93422202c_laries
corries94026802co_rries
coteries10422712coteries
covariates1545782covariates
cowries124218012co_wries
notaries8314932notaries
rosaries8312782rosaries
rotaries8315692rotaries
varies94330872__varies
vivaries1439262vivaries
votaries11312012votaries
actuaries1147573actuaries
ambaries123312383ambaries
angaries9314393angaries
apiaries10312733apiaries
avarices1337183_avarices
aviaries1139783aviaries
binaries10314183binaries
botanies10312853botanies
boweries13312293boweries
calories102919563calories
calvarias1447663calvarias
cares77369183c__ar_es
caribes113715643c__aribes
carices114220953c__arices
caried94528693c__aried
carles85435083c__arles
carnies94123963c__arnies
carries94328013c_arries
carses85233653c__arses
cartes86239473c__artes
carves115128453c__arves
cavalier1348183cavalier
cavaliers1455623cavaliers
cavallies1446393cavallies
caviares1337993caviar_es
cavies114525003c__avies
cavities131412613cavities
celeries10316313celeries
chares115631803c_har_es
charges134615983c_harges
charier124317903c_harier
chariest13315513c_hariest
charlies133414233c_harlies
cheapies1539033cheapies
cherries131812993cherries
chivalries1843963chivalries
chivarees1744383chivarees
chivaried1844053chivaried
civies114116443civ__ies
civvies1555843civ_vies
claroes93113743c_laroes
coaches144018693co_aches
coalier93416183co_alier
coaliest10316223co_aliest
coarse84813903co_arse_
coarsen93210323co_arsen
coarsens10348123co_arsens
coarser93211203co_arser
coarsest1039163co_arsest
coatees93816553co_atees
coatis85122603co_ati_s
coaxes154715633co_a_xes
cocaines121314443cocaines
cocains111313923coca_ins
coderives1547483coderives
codifies1439643codifies
codrives1437663co_drives
coerces11311943co_erces
cohabits1545413cohabits
coheres122917693coher_es
colies84837053co__lies
collies94326583co_llies
colonies103620013colonies
colorizes203014523colorizes
colures9315143colur_es
comakes154413643coma_kes
comates114123643coma_tes
comatiks16148043comatiks
comedies13311843comedies
comities12317793comities
commies133718453co_mmies
companies15311803companies
compares143816433compar_es
complies14314523complies
comprise14310813comprise
comprises15510943comprises
comprizes2468943comprizes
comrades13149773comrades
conchies153214853conchies
congeries12316403congeries
conies84338593co__nies
contraries12711933contraries
contrives14311703contrives
converges1538383converges
converses14311163converses
cookeries151210643cookeries
cookies133719273co_okies
coolies93824963co_olies
coonties10513803coonties
cooperies131113323cooperies
cooties93725733co_oties
copies104130313co__pies
coracles121811163coracles
corbies113520123co_rbies
cores76361853co__r_es
corodies11313693corodies
coronaries12410243coronaries
corrades111211263corrades
corrie83621233co_rrie_
corses84433463co__rses
corves115122523co__rves
cosies84932163co__sies
costmaries1446913costmaries
coterie9417403coterie_
coumarins1347023coumarins
counties10316283counties
countries11313613countries
courages11311393courages
courier93617893co_urier
couriers103213173co_uriers
courses94218893co_urses
couvades1435613couva_des
covariances1853733covariances
covariant1447863covariant
covariate1446213covariate
covary1438743covar__y
covarying1844133covarying
coverages1538833coverages
covered133315293cover_ed
coverer123113523cover_er
coverers132712123coverers
covering142215743covering
coverings15217913coverings
coverless1436803coverless
coverlet13413013coverlet
coverlets1437053coverlets
coverlids1544763coverlids
covers114627963cover__s
coversines15128633coversines
coverts124813813cover_ts
coverups1544063coverups
coves105539173cov___es
covins114618063cov__ins
cowages13310943cowa_ges
cowardices1842373cowardices
cowards1339613cowar_ds
cowpies143314283co_wpies
cowrie113814283co_wrie_
cowrites133011593co_writes
coxalgies1943243coxalgies
cozies174521413co__zies
crazies183413853c_razies
cries75438403c___ries
cumarins1238643cumarins
curacies12311763curacies
curares94916853curar_es
curarines11710553curarines
curaris94114773curari_s
curarizes2078173curarizes
curies84934023c__uries
curries93723163c_urries
dataries9314033dataries
dearies83526273_dearies
diaries83321953_diaries
dories75232363do__ries
dovekies16115003dovekies
doweries12411933doweries
dowries114413983do_wries
drearies92313413drearies
feodaries1346373feodaries
friaries11310083friaries
goalies8316023go_alies
hoagies112811993ho_agies
hoarier104211743ho_arier
hoariest11312883ho_ariest
ivories10310713_ivories
liveries11314373liveries
lories64933043lo__ries
lorries74518353lo_rries
lovages1138033lova_ges
lovelies1139893lovelies
moperies12313873moperies
movables15175573movables
movies115118453mov__ies
notarizes1848713notarizes
octonaries1246003octonaries
oogamies1147413oogamies
ovarial1037613_ovarial
ovarian1037643_ovarian
ovarioles1244613_ovarioles
ovaritis1145953_ovaritis
overlies112417043_overlies
paries84742523__paries
poetries10315583poetries
polarise10513903polarise
polarises11514073polarises
polarizes20513023polarizes
poperies12316793poperies
poverties1439513poverties
recoveries1547473recoveries
reveries112518513reveries
rivalries1245003rivalries
roadies83317443ro_adies
roperies10315773roperies
roseries8317323roseries
salaries8319593salaries
savarins1139893savarins
savories11311273savories
solarise8512543solarise
solarises9512703solarises
solarizes18511613solarizes
souaris7312333souari_s
sudaries9312753sudaries
toadies82914863to_adies
topiaries1147113topiaries
tories65435883to__ries
tovarich1643453tovarich
tovariches1841943tovariches
tovarish1445123tovarish
tovarishes1643353tovarishes
unvaried1239683unvaried
vagaries12310293vagaries
varias95019913__varias
varices123313573__varices
varied104817863__varied
varier94619353__varier
variers103712663__variers
varves124414783__varves
voleries11313233voleries
wearies103020233_wearies
worries104117133wo_rries

Search took 8 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 Limit1461622407.26320124.2
3Display Results2402400.0962500.0
 (SQL Overall)1786912407.78222962.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.