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

218 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
voleries1131323(None) 
boweries13312292boweries
celeries10316312celeries
coteries10422702coteries
dolerites101410892dolerites
doweries12411932doweries
fooleries1248742fooleries
moperies12313872moperies
poperies12316792poperies
roperies10315762roperies
roseries8317312roseries
veeries102916892v_eeries
veneries112815032veneries
vineries112716042vineries
votaries11312012votaries
aeries64737783__aeries
allergies10137783allergies
amberies122514683amberies
aperies9423203_aperies
arteries8321483arteries
bakeries14312193bakeries
belfries1336983belfries
bobberies12107893bobberies
boiseries11411043boiseries
boleros9310293boler_os
boletes9316063bole_tes
bolshies1338693bolshies
booteries11312773booteries
butleries11710073butleries
cajoleries1944763cajoleries
calories102919553calories
claries93422203_claries
clergies1137903_clergies
clerics1149333_clerics
clerids1049093_clerids
coderives1547483coderives
coerces11311943co_erces
coheres122917693coher_es
coleuses1039723coleuses
colies84837053col__ies
collieries1248333collieries
collies94326583col_lies
colonies103620013colonies
colorizes203014523colorizes
colures9315143colur_es
comedies13311843comedies
congeries12316403congeries
cookeries151210633cookeries
cooperies131113313cooperies
corries94026793co_rries
coterie9417403coterie_
covaries13413253covaries
cowries124218013co_wries
cutleries1179213cutleries
cycleries1647033cycleries
dodgeries1246593dodgeries
doggeries1246673doggeries
dolerite9611773dolerite
dollies83620983dol_lies
dories75232363do__ries
dovekies16115003dovekies
dowries114413983do_wries
drolleries1145443drolleries
duperies11312813duperies
eateries8324313eateries
elegies81312903_elegies
emeries91620023_emeries
emperies12314563emperies
faeries104118993_faeries
fakeries1559833fakeries
fineries112416743fineries
folkies143612253fol_kies
follies103618943fol_lies
fopperies1666013fopperies
forgeries13310003forgeries
fulleries1248723fulleries
galeres83514333galer_es
galleries10311703galleries
glories81915913_glories
gomerils1146793gomerils
groceries1249503groceries
helleries122611683helleries
holies94630033hol__ies
hollies103420813hol_lies
hosieries1249213hosieries
ivories10310713ivo__ries
japeries17311463japeries
jobberies20115423jobberies
joineries1648103joineries
jollies143516273jol_lies
levies93919863__levies
liveries11314373liveries
lollies73116923lol_lies
lories64933043__lories
lorries74518343lo_rries
lotteries9311073lotteries
lovelies1139893lovelies
miseries10320403miseries
mockeries17128263mockeries
modernes1138423modernes
moieties10311263moieties
molies84429513mol__ies
mollies93420233mol_lies
monkeries15129913monkeries
naperies10313903naperies
niteries8318383niteries
notaries8314933notaries
oldies7314423_ol_dies
oleates7417833_oleates
olefines1137323_olefines
olefins1037493_olefins
oleines7313393_oleines
oleins6313523_ole_ins
ologies8615023_ologies
onerier7311613_onerier
oneriest8313443_oneriest
oogenies9311583oogenies
oologies9312993oologies
orreries8310123orreries
ovaries10312653_ovaries
overlies112417043_overlies
pedleries1298783pedleries
peeries93623023_peeries
pelerines11311843pelerines
peltries10313023peltries
pineries102419083pineries
poesies93217403po_esies
poetries10315583poetries
polarise10513903polarise
polarises11514073polarises
polarizes20513023polarizes
poleaxes1767273poleaxes
poleis86018353pole_i_s
polemics1448183polemics
polemizes2248153polemizes
polers84225643poler__s
policies122415663policies
polies84034583pol__ies
polities102722343polities
potteries11313593potteries
poultries1148453poultries
poverties1439513poverties
queries16315873_queries
reveries112518513reveries
rifleries1247683rifleries
robberies13107393robberies
rockeries15128973rockeries
rogueries1047003rogueries
rookeries13138173rookeries
rosaries8312783rosaries
rotaries8315693rotaries
ruderies9311333ruderies
salaries8319573salaries
sclerites1139443sclerites
sealeries9313133sealeries
series64540973__series
soberizes2098963soberizes
solarise8512543solarise
solarises9512703solarises
solarizes18511613solarizes
soldieries1145593soldieries
solecise1089073solecise
solecises1189103solecises
solecizes2087863solecizes
soleret7321233soler_et
solerets839693solerets
soleuses838073soleuses
sorceries1149933sorceries
toggeries1146213toggeries
toiletries1046613toiletries
tolerates9312123tolerates
tories65435883to__ries
towerier1137123towerier
toweriest1246533toweriest
vagaries12310293vagaries
valences1388513valences
valencies1446413valencies
valerates12310543valerates
valerian1147123valerian
valerians1245343valerians
valeric1238303valeri_c
valkyries1952633valkyries
valorise112110303valorise
valorises122210183valorises
valorizes21249073valorizes
varies94330873v__aries
varletries1346033varletries
vegies104314273v__egies
velarizes2148643velarizes
velures1039093velur_es
verges104320183v__erges
verier94620963v__erier
veriest103719133v__eriest
verites103822263v__erites
vermes115019143v__ermes
verses94223763v__erses
verves124617883v__erves
vestries11314053vestries
vilifies1439593vilifies
violences1445493violences
vivaries1439263vivaries
volatiles1246133volatiles
volery1237873voler__y
voles86234043vol___es
voltages1237253voltages
voltes94915583vol__tes
volumes12298233vol_umes
volutes102710983vol_utes
volutins1188003volutins
volvoxes2142243volvoxes
vomerine1347683vomerine
vomers115614943vomer__s
voters95017443voter__s
vowelizes2443933vowelizes
vowers124317183vower__s
wineries112316533wineries
wolverines1654223wolverines
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 Limit1461622187.06020702.8
3Display Results2182180.0962270.8
 (SQL Overall)1786912187.57923577.1
 
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.