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

129 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
vivaries143926(None) 
aviaries1139782avi_aries
binaries10314182binaries
chivaries1757432chivaries
covaries13413252covaries
diaries83321952di_aries
ivories10310712_ivories
liveries11314372liveries
ovaries10312652_ovaries
rivalries1245002rivalries
vagaries12310292vagaries
varies94330872__varies
vineries112716042vineries
vivaces1536412viva_ces
vivaria1346982vivari_a
vivarium1644442vivarium
vivariums1742962vivariums
vivifies1747022vivifies
votaries11312012votaries
ambaries123312383ambaries
angaries9314393angaries
apiaries10312723apiaries
avarices1337183_avarices
bialies93618413bi_alies
bigamies1337373bigamies
bivalves1643383bivalves
bizarres1953793bizarres
calvaries1449803calvaries
canaries10318943canaries
caries85147623__caries
cavalries1446363cavalries
chivalries1843963chivalries
chivarees1744383chivarees
chivaried1844053chivaried
civies114116443civ__ies
civvies1555843civ_vies
claries93422203_claries
covaried1448003covaried
dataries9314033dataries
dearies83526273_dearies
dietaries10410663dietaries
digamies1238643digamies
diverges13258313diverges
divorces1445673divorces
divvies1457663div_vies
drearies92313413drearies
filarees1187643filarees
fineries112416743fineries
friaries11310083friaries
gisarmes1144433gisarmes
ivies84215763_iv__ies
libraries1146993libraries
litanies8310993litanies
liveried1238733liveried
livres94311863liv_r_es
miladies1139923miladies
miseries10320403miseries
niteries8318383niteries
notaries8314933notaries
paries84742513__paries
pineries102419083pineries
piracies12312643piracies
piscaries13410073piscaries
primaries13410833primaries
privacies1646803privacies
quinaries1857873quinaries
reveries112518513reveries
rivages1138873riva_ges
rosaries8312783rosaries
rotaries8315693rotaries
salaries8319573salaries
savarins1139893savarins
savories11311273savories
shivarees1543953shivarees
sudaries9312753sudaries
unvaried1239683unvaried
urinaries949203urinaries
varias95019903__varias
varices123313573__varices
varied104817863__varied
varier94619353__varier
variers103712663__variers
varves124414783__varves
veeries102916893v_eeries
velarizes2148643velarizes
veneries112815033veneries
vestries11314053vestries
vibrates132210613vibrates
vibrios1235803vi_brios
vicarages1574433vicarages
vicarates1487623vicarates
vicarial1347793vicarial
vicariates1565533vicariates
vicarious1445583vicarious
vicars11712263vicar__s
vichies15310623vi_chies
victories1448913victories
vilifies1439593vilifies
vinasses1135703vinasses
vinifies1439873vinifies
viragoes1245233viragoes
vires84529683vi__r_es
visages1138693visa_ges
visards11328153visar_ds
vitalise11310743vitalise
vitalises12310093vitalises
vitalizes2139923vitalizes
vitamines1446553vitamines
vitamins1347083vitamins
vitrains1138283vitrains
vitrics12198553vi_trics
vitrines112610913vi_trines
vivace1436553viva_ce_
vivacious1743923vivacious
vivacities1844483vivacities
vivacity1943993vivacity
vivary1536983vivar__y
vivas114815023viva___s
viverrids1642803viverrids
viverrines1644133viverrines
vivers124717363viver__s
vivified1845893vivified
vivifier1745173vivifier
vivifiers1843673vivifiers
vizarded2242753vizarded
vizards20377263vizar_ds
voleries11313233voleries
wearies103020223_wearies
wineries112316533wineries

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.1531167915.0
2DLD Change Limit1461621297.39319770.3
3Display Results1291290.0632047.6
 (SQL Overall)1786911297.60923484.2
 
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.