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
corries94026792co_rries
coteries10422702coteries
covariates1545782covariates
cowries124218012co_wries
notaries8314932notaries
rosaries8312782rosaries
rotaries8315692rotaries
varies94330872__varies
vivaries1439262vivaries
votaries11312012votaries
actuaries1147563actuaries
ambaries123312383ambaries
angaries9314393angaries
apiaries10312723apiaries
avarices1337183_avarices
aviaries1139783aviaries
binaries10314183binaries
botanies10312853botanies
boweries13312293boweries
calories102919543calories
calvarias1447663calvarias
cares77369183c__ar_es
caribes113715643c__aribes
carices114220953c__arices
caried94528693c__aried
carles85435083c__arles
carnies94123963c__arnies
carries94328013c_arries
carses85233653c__arses
cartes86239473c__artes
carves115128453c__arves
cavalier1348173cavalier
cavaliers1455613cavaliers
cavallies1446393cavallies
caviares1337993caviar_es
cavies114525003c__avies
cavities131412613cavities
celeries10316313celeries
chares115631803c_har_es
charges134615983c_harges
charier124317903c_harier
chariest13315503c_hariest
charlies133414233c_harlies
cheapies1539033cheapies
cherries131812983cherries
chivalries1843963chivalries
chivarees1744383chivarees
chivaried1844053chivaried
civies114116443civ__ies
civvies1555843civ_vies
claroes93113733c_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
comedies13311833comedies
comities12317793comities
commies133718453co_mmies
companies15311803companies
compares143816433compar_es
complies14314523complies
comprise14310813comprise
comprises15510943comprises
comprizes2468943comprizes
comrades13149773comrades
conchies153214853conchies
congeries12316403congeries
conies84338593co__nies
contraries12711933contraries
contrives14311703contrives
converges1538373converges
converses14311163converses
cookeries151210633cookeries
cookies133719273co_okies
coolies93824963co_olies
coonties10513803coonties
cooperies131113313cooperies
cooties93725733co_oties
copies104130303co__pies
coracles121811163coracles
corbies113520123co_rbies
cores76361853co__r_es
corodies11313693corodies
coronaries12410223coronaries
corrades111211263corrades
corrie83621223co_rrie_
corses84433463co__rses
corves115122523co__rves
cosies84932153co__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
covering142215723covering
coverings15217893coverings
coverless1436803coverless
coverlet13413013coverlet
coverlets1437053coverlets
coverlids1544753coverlids
covers114627963cover__s
coversines15128633coversines
coverts124813813cover_ts
coverups1544063coverups
coves105539173cov___es
covins114618063cov__ins
cowages13310933cowa_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
lorries74518343lo_rries
lovages1138033lova_ges
lovelies1139893lovelies
moperies12313873moperies
movables15175573movables
movies115118453mov__ies
notarizes1848713notarizes
octonaries1246003octonaries
oogamies1147413oogamies
ovarial1037613_ovarial
ovarian1037643_ovarian
ovarioles1244603_ovarioles
ovaritis1145953_ovaritis
overlies112417043_overlies
paries84742513__paries
poetries10315583poetries
polarise10513903polarise
polarises11514073polarises
polarizes20513023polarizes
poperies12316793poperies
poverties1439513poverties
recoveries1547463recoveries
reveries112518513reveries
rivalries1245003rivalries
roadies83317443ro_adies
roperies10315763roperies
roseries8317313roseries
salaries8319573salaries
savarins1139893savarins
savories11311273savories
solarise8512543solarise
solarises9512703solarises
solarizes18511613solarizes
souaris7312333souari_s
sudaries9312753sudaries
toadies82914863to_adies
topiaries1147113topiaries
tories65435883to__ries
tovarich1643453tovarich
tovariches1841943tovariches
tovarish1445123tovarish
tovarishes1643353tovarishes
unvaried1239683unvaried
vagaries12310293vagaries
varias95019903__varias
varices123313573__varices
varied104817863__varied
varier94619353__varier
variers103712663__variers
varves124414783__varves
voleries11313233voleries
wearies103020223_wearies
worries104117133wo_rries

Search took 10 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.1561145455.1
2DLD Change Limit1461622408.87616467.1
3Display Results2402400.0932580.6
 (SQL Overall)1786912409.12519582.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.