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

179 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
rosaries831278(None) 
roseries8317311roseries
rotaries8315691rotaries
covaries13413252covaries
notaries8314932notaries
ovaries10312652_ovaries
roadies83317442ro_adies
roperies10315762roperies
rosaria749252rosari_a
rosarian847592rosarian
rosarians945792rosarians
rosarium10126912rosarium
rosariums11124762rosariums
rosemaries1246032rosemaries
votaries11312012votaries
ambaries123312383ambaries
angaries9314393angaries
apiaries10312733apiaries
aviaries1139783aviaries
binaries10314183binaries
boiseries11411043boiseries
bossies94116833bos_sies
botanies10312853botanies
boweries13312293boweries
bursaries1157643bursaries
canaries10318943canaries
caries85147623__caries
claries93422203_claries
coronaries12410233coronaries
corries94026803co_rries
cosies84932153cos__ies
costmaries1446913costmaries
coteries10422703coteries
covaried1448003covaried
cowries124218013co_wries
crossties1139013crossties
dataries9314033dataries
dearies83526273_dearies
descries11311923descries
diaries83321953_diaries
dories75232363do__ries
dosages92310803dosa_ges
doweries12411933doweries
dowries114413983do_wries
drearies92313413drearies
droshkies1762563droshkies
droskies13186343dros_kies
feodaries1346373feodaries
friaries11310083friaries
gisarmes1144433gisarmes
glossaries1144513glossaries
goalies8316023go_alies
gramaries12128313gramaries
granaries10159883granaries
groceries1249503groceries
hoagies112811993ho_agies
hoarier104211743ho_arier
hoariest11312883ho_ariest
hosieries1249213hosieries
lories64933043lo__ries
lorries74518353lo_rries
miseries10320403miseries
moperies12313873moperies
mosaics1138073mosa_ics
nostrils848183nostrils
notarizes1848713notarizes
oogamies1147413oogamies
orreries8310123orreries
ossuaries944553ossuaries
ostiaries948803_ostiaries
paries84742513__paries
pastries101517423pastries
pessaries11108663pessaries
piscaries13410073piscaries
poetries10315583poetries
polarise10513903polarise
polarises11514073polarises
polarizes20513023polarizes
poperies12316793poperies
posies84431433pos__ies
posties93128813pos_ties
primaries13410833primaries
proscribes16125353proscribes
prosodies1249733prosodies
prossies101515223pros_sies
prosties101421193pros_ties
rabies85226023r__abies
ramies84630463r__amies
rares55247443r__ar_es
rasures7312013rasur_es
ratanies8312923ratanies
readies83324713r_eadies
reburies10311143reburies
recarries1147863recarries
redries83721713r_edries
refries104419733r_efries
remarries1147673remarries
resails74616743resa_ils
resales74724903resa_les
reserves111011983reserves
respires10311903respires
restrikes1339413restrikes
restrives12310663restrives
resurges9310123resurges
retries74129073r_etries
reveries112518513reveries
rivalries1245003rivalries
roaches123616213ro_aches
roadie72813813ro_adie_
roared75015393ro_ar_ed
roarer63914333ro_ar_er
roarers73812743ro_arers
roaring82916003ro_aring
roarings9248293ro_arings
roars55622243ro_ar__s
robberies13107393robberies
robotries1147323robotries
rockabies1744223rockabies
rockeries15128973rockeries
rogueries1047003rogueries
rolamites1148243rolamites
romaines10512523romaines
romajis1635913romaji_s
romances12310793romances
romanise10312133romanise
romanises11311573romanises
romanizes20310933romanizes
roofies103014413ro_ofies
rookeries13138173rookeries
rookies113917103ro_okies
roomies93017243ro_omies
rosacea944713rosa_cea
rosaceas1043723rosaceas
rosary92810353rosar__y
roscoes9310923ros_coes
rosehips1344253rosehips
roselles8310713roselles
roses56445773ros___es
rosettes8310343rosettes
roshis9311793ros_hi_s
rosier64221263ros__ier
rosiest73919213ros__iest
rosins64521863ros__ins
rosolios875273rosolios
rostrums1046083rostrums
rotates72819773rota_tes
roturier836033roturier
roturiers944553roturiers
roughies1298323roughies
rowdies113112693ro_wdies
royalties1244913royalties
ruderies9311333ruderies
salaries8319593salaries
sanies63031953__sanies
sarees65329943__sarees
sarges75128593__sarges
sarins63932623__sarins
saris54544953__sari_s
sauries72821623__sauries
scries85226823__scries
series64540973__series
solarise8512543solarise
solarises9512703solarises
solarizes18511613solarizes
souaris7312333souari_s
sudaries9312753sudaries
toadies82914863to_adies
topiaries1147113topiaries
tories65435883to__ries
urinaries949203urinaries
usuries7510633_usuries
vagaries12310293vagaries
varies94330873__varies
vestries11314053vestries
vivaries1439263vivaries
voleries11313233voleries
wastries111212883wastries
wearies103020223_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.420425454.8
2DLD Change Limit1461621796.75021653.6
3Display Results1791790.0802237.5
 (SQL Overall)1786911797.25024647.0
 
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.