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

298 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
vanities11141449(None) 
canities101519261canities
sanities81219771sanities
vanitied12138211vanitied
amities9317382_amities
banties94324762ban_ties
cavities131412612cavities
dainties9312402dainties
inanities9312442inanities
laities7320342la_ities
laxities1539092laxities
lenities8315942lenities
ovalities12119802ovalities
panties94230932pan_ties
parities10522972parities
rarities8316332rarities
sanitise81511812sanitise
sanitises91111742sanitises
sanitizes181210132sanitizes
unities72520152_unities
vacuities1447142vacuities
vanishes141610752vanishes
vanitories1346902vanitories
varieties1259202varieties
varsities1239242varsities
vastities1248932vastities
verities111418042verities
vinifies1439872vinifies
acuities10312453acuities
alibies9313323_alibies
amanitins1147133amanitins
amenities11310433amenities
aminities11312913aminities
analities9715873analities
anilines8415143_anilines
anilins7416793_anilins
anilities9516003_anilities
animes84719593_ani_mes
animis84615943_animi_s
anises64826693_ani_ses
annuities947463annuities
anomies93316993_anomies
antes56334323_an_t_es
antics84621453_an_tics
antis55033313_an_ti_s
antres65021003_an_tres
anxieties1646263_anxieties
aunties73920073_aunties
avidities13107613avidities
axites134913833_axit_es
bailies94120203ba_ilies
banalities1249813banalities
bandies104124863ban_dies
banditries1345343banditries
banishes131812463banishes
banshies131110663banshies
barites94322333barit_es
basifies13310493basifies
bawties124214313ba_wties
bonitoes1038153bonitoes
bovinities1546013bovinities
calvities1438943calvities
canaries10318943canaries
candies104125613can_dies
canikins14219163canikins
canines93724033cani_nes
caninities12410493caninities
canopies12311853canopies
cantles94721413can_tles
carnifies1439893carnifies
carnitines1277813carnitines
catties94023053ca_tties
cavitied14126813cavitied
cecities12312043cecities
chanties132615803chan_ties
charities14312743charities
cities84524853__cities
clarities11312483clarities
comities12317793comities
cyanites132610163cyanit_es
dacites101114593dacit_es
dacoities1248213dacoities
dailies84219263da_ilies
daintier937403daintier
daintiest1039153daintiest
dairies84217733da_iries
daisies84217093da_isies
dakoities1444673dakoities
damnifies1545543damnifies
dandies94121443dan_dies
dandifies1476893dandifies
danishes121710493danishes
dauties83315763da_uties
dawties113312703da_wties
deities82621923_deities
densities10310793densities
dignities1149593dignities
dimities11314003dimities
divinities1447733divinities
dualities10310443dualities
dunites8313593dunit_es
edacities1247773edacities
enmities10611353enmities
entities8617413entities
equities17310773equities
evanishes1545603evanishes
fairies103516043fa_iries
falsities1248133falsities
families1339443families
fanatics1367183fanatics
fancies124018783fan_cies
fancifies1767083fancifies
fannies103415643fan_nies
fatties103018203fa_tties
fatuities1246913fatuities
ferities111416713ferities
finites10315923finit_es
fixities1838213fixities
gahnites1235703gahnit_es
gaieties9310183gaieties
gantries91413783gantries
gaseities1047083gaseities
gasifies1238693gasifies
gayeties1236883gayeties
genitives1346663genitives
granites92116363granit_es
gravities1338303gravities
gunites8313123gunit_es
habitues13306413habitues
halites103221193halit_es
hankies143617763han_kies
hantles104117513han_tles
humanities1547063humanities
ignifies1277563ignifies
ignites81310583ignit_es
insanities1049423insanities
janitors1536853janitors
kainites1238793kainit_es
kyanites15216683kyanit_es
laniaries9411213laniaries
lanitals837723lanitals
lanosities1047913lanosities
latinities10410163latinities
lenites7818443lenit_es
lenitives1247503lenitives
levities11310713levities
magnifies1547283magnifies
manatees10310423manatees
manikins14189723manikins
manilles102312603manilles
maniples12269423maniples
manitos9314053manit_os
manitous1039173manitous
manitus9310923manit_us
mannites10312613mannit_es
mantes84430783man_t_es
mantids103113623man_tids
mantis83926033man_ti_s
mantises10317923mantises
mantles94820703man_tles
minifies13312903minifies
nancies93516843nan_cies
nannies73015203nan_nies
nasties73520493na_sties
nazifies2036063nazifies
nifties102612503__nifties
nineties8312913nineties
nites55736343__nit_es
nitres65519333__nitres
nixies135313873__nixies
nudities939683nudities
oddities1046603oddities
opacities1347943opacities
oralities91214123oralities
ornithes1136423ornithes
ovaritides1443973ovaritides
ovaritis1145953ovariti_s
pacifies15311223pacifies
paintier1048793paintier
paintiest11310563paintiest
pandies104224503pan_dies
panfries13149203panfries
panicles121010113panicles
pansies94521983pan_sies
pantie84326473pan_tie_
pantiles103617153pantiles
pantries101817393pantries
parties93230863pa_rties
pasties94529813pa_sties
patties93425143pa_tties
paucities1348503paucities
pinites9319533pinit_es
pities83828083__pities
polities102722343polities
punties94520783pun_ties
purities10316283purities
qualities18311223qualities
quantities1946293quantities
ramifies13310503ramifies
ramilies10311833ramilies
randies84225663ran_dies
rarifies11311933rarifies
ratifies11313513ratifies
ratites74920683ratit_es
raucities1148163raucities
realities9316313realities
safeties1139163safeties
salifies11314793salifies
salinities10410953salinities
salties73725773sa_lties
samites93118713samit_es
sanctities1247553sanctities
sanicles10149943sanicles
sanidines1048043sanidines
sanies63031953san__ies
sanitaries1049913sanitaries
sanitates9611733sanitates
sanitised10147353sanitised
sanitize171410083sanitize
sanitized19138173sanitized
sanitizer18126733sanitizer
sanitizers19104493sanitizers
santims9312603san_tims
santirs7312963san_tirs
satieties939383satieties
scanties103215423scan_ties
shanties113116583shan_ties
suavities1248413suavities
tanistries1047063tanistries
tansies74521243tan_sies
tantivies1247103tantivies
tatties74120343ta_tties
taxites1449673taxit_es
tensities9311333tensities
tenuities949763tenuities
trinities9313343trinities
unifies102714713_unifies
unites65024853_unit_es
unitizes1739133_unitizes
unties64326923_un_ties
uranites82514643uranit_es
urbanities1245333urbanities
vacates12312833vacat_es
vagaries12310293vagaries
vagilities1447953vagilities
vaginitis1344273vaginiti_s
vaginitises1543393vaginitises
vahines133410523vahi_nes
validities1447303validities
valines104520213vali_nes
valises103516263vali_ses
vandykes1942163vandykes
vanes85130973van___es
vanillas11228123vanillas
vanillins1245543vanillins
vanished15207743vanished
vanisher14167453vanisher
vanishers15186613vanishers
vanitory1445733vanitory
vanity12311933vanit__y
vantages12119023vantages
vapidities1646383vapidities
variates111214983variates
varices123313573vari_ces
varies94330873va__ries
varioles11711123varioles
varnishes15207913varnishes
vastier103613203va_stier
vastiest112713073va_stiest
vaticides1546603vaticides
vaultier1144293vaultier
vaultiest1234833vaultiest
vauntie1036633vauntie_
vawntie1343943vawntie_
velites103417303velit_es
venalities131510723venalities
veneries112815033veneries
venines103516613veni_nes
venires103012453veni_res
venosities1347473venosities
veracities1549503veracities
verifies141313483verifies
verites103822263verit_es
vicinities1547463vicinities
viduities1346113viduities
vilifies1439593vilifies
vineries112716043vineries
vinified1537543vinified
vinosities1346803vinosities
vitalities1349093vitalities
vivacities1844483vivacities
vivifies1747023vivifies
vocalities1549393vocalities
vomitives1744613vomitives
voracities1547063voracities
wapitis1236473wapiti_s
whities133113253_whities
zanies153219673zan__ies

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.436409841.7
2DLD Change Limit1461622987.09320606.5
3Display Results2982980.1262365.1
 (SQL Overall)1786912987.65523343.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.