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

386 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
sanities8121976(None) 
canities101519251canities
sanitise81511811sanitise
sanitises91111741sanitises
sanitizes181210131sanitizes
vanities111414491vanities
amities9317382_amities
banties94324762ban_ties
cavities131412612cavities
dainties9312402dainties
inanities9312442inanities
insanities1049412insanities
laities7320342la_ities
laxities1539092laxities
lenities8315942lenities
panties94230932pan_ties
parities10522972parities
rarities8316332rarities
safeties1139162safeties
salifies11314792salifies
salinities10410932salinities
salties73725772sa_lties
samites93118712samit_es
sanctities1247552sanctities
sanicles10149942sanicles
sanidines1048042sanidines
sanies63031952san__ies
sanitaries1049912sanitaries
sanitates9611732sanitates
sanitised10147352sanitised
sanitize171410072sanitize
sanitized19138172sanitized
sanitizer18126732sanitizer
sanitizers19104492sanitizers
santims9312592san_tims
santirs7312962san_tirs
satieties939372satieties
scanties103215422scan_ties
shanties113116572shan_ties
suavities1248412suavities
unities72520152_unities
vanitied12138212vanitied
acuities10312453acuities
alibies9313323_alibies
amanitins1147133amanitins
amenities11310433amenities
aminities11312903aminities
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
ascites9312603ascit_es
aunties73920073_aunties
axites134913833_axit_es
bailies94120203ba_ilies
banalities1249813banalities
bandies104124863ban_dies
banditries1345343banditries
banishes131812463banishes
banshies131110663banshies
barites94322333barit_es
basifies13310493basifies
bawties124214313ba_wties
bonitoes1038153bonitoes
calvities1438933calvities
canaries10318943canaries
candies104125613can_dies
canikins14219163canikins
canines93724033cani_nes
caninities12410473caninities
canopies12311853canopies
cantles94721413can_tles
carnifies1439893carnifies
carnitines1277813carnitines
catties94023053ca_tties
cavitied14126813cavitied
cecities12312043cecities
chanties132615803chan_ties
charities14312743charities
cities84524853__cities
clarities11312483clarities
comities12317793comities
cyanites132610153cyanit_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
disunities1177783disunities
dualities10310443dualities
dunites8313593dunit_es
edacities1247773edacities
enmities10611353enmities
entities8617413entities
equities17310773equities
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
janitors1536853janitors
kainites1238793kainit_es
kyanites15216683kyanit_es
laniaries9411213laniaries
lanitals837723lanitals
lanosities1047913lanosities
latinities10410153latinities
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
nasalities1048553nasalities
nasties73520493na_sties
nazifies2036063nazifies
nifties102612503__nifties
nineties8312913nineties
nites55736343__nit_es
nitres65519333__nitres
nixies135313873__nixies
nudities939683nudities
oddities1046603oddities
opacities1347943opacities
oralities91214113oralities
ornithes1136423ornithes
ovalities12119803ovalities
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
realities9316303realities
sabines94318483sabi_nes
sacristies1276033sacristies
safetied1244663safetied
sagacities1345623sagacities
saices84221803sa_i_ces
saimins9312113sa_imins
sainted84114243saint_ed
sainting93215733sainting
saintlier954623saintlier
saintliest1046003saintliest
saints65122423saint__s
saithe94713913sa_ithe_
saiyids11174893sa_iyids
salacities1248223salacities
salaries8319573salaries
salicines11310003salicines
salicins10310933salicins
salified12310363salified
salines74029413sali_nes
salinizes1839143salinizes
sallies73227813sa_llies
salsifies1247253salsifies
saltie63422423sa_ltie_
saltier74318633sa_ltier
saltiers83411953sa_ltiers
saltiest83117713sa_ltiest
saltines82917793saltines
saltires83112423saltires
salutes73716253salut_es
samite83020603samit_e_
sanative11310473sanative
sanctifies1554983sanctifies
sanctify1644493sanctify
sanction1049533sanction
sanctions1138873sanctions
sanctity1345593sanctity
sanctums1244013sanctums
sandflies1346503sandflies
sandhis1139993sandhi_s
sandier84017843san_dier
sandiest93218683san_diest
sandpiles1246303sandpiles
sandpits1146843sandpits
sanes55649073san___es
sangrias938373sangrias
sanguines1047183sanguines
sanicle91210263sanicle_
sanidine939853sanidine
sanious7514103sani_ous
sanitary1146753sanitary
sanitate8612043sanitate
sanitated1068993sanitated
sanity9316203sanit__y
sanseis73011603sansei_s
santimi938783san_timi
santimu938553san_timu
santir6315243san_ti_r
santols73513323san_tols
santos64421833san_t_os
santurs7310763san_turs
sapidities1347993sapidities
saponifies1544703saponifies
saponites1139943saponit_es
sapotes9313933sapot_es
sassies74719263sa_ssies
sates54949323sa__t_es
satiates8314633satiates
satins64930483sa__tins
satires72617573sati_res
satirise8310683satirise
satirises9410193satirises
satirizes1849393satirizes
satis55633673sa__ti_s
satisfies1245323satisfies
sauries72821623sa_uries
sautes63924913sa_ut_es
savates10312953savat_es
savines104417633savi_nes
savories11311273savories
savvies1337603sa_vvies
sawflies1444733sawflies
saxonies1537913saxonies
scantier10309983scan_tier
scantiest112611003scan_tiest
scarcities1446403scarcities
scarifies1439603scarifies
scotties1039743scotties
senates73322583senat_es
seniles72618023seni_les
senilities10312993senilities
seniti64317213seniti__
sensitise947293sensitise
sensitises1047643sensitises
sensitives1346133sensitives
sensitizes1946963sensitizes
sentries81318053sentries
serenities10411063serenities
shandies122714103shan_dies
shannies113411253shan_nies
shantihs14276203shan_tihs
shantis103313093shan_ti_s
shelties111111373shelties
shindies122610503shindies
shinnies113010913shinnies
shorties11414573shorties
sienites8311913sienit_es
signifies1347063signifies
sinicizes2046793sinicizes
sites56045433s__it_es
sixties14310973s_ixties
skites104418033s_kit_es
smarties10312873smarties
smites83921923s_mit_es
smithies1337913s_mithies
snathes104816493s_nathes
snipes83917393s_ni_pes
snitches13148983s_nitches
snits54124833s_nit__s
societies1148803societies
sodalities11138703sodalities
softies103414613s_ofties
somites94219123somit_es
sonnies7315223son_nies
sonorities10910653sonorities
sopites93817173sopit_es
sorites73825243sorit_es
sorties74126403s_orties
sparsities1247323sparsities
spinnies103210543spinnies
spites84127333s_pit_es
spitzes1849173s_pitzes
sprites94220333sprit_es
spritzes1946933spritzes
staithes1138953staithes
stanines85115673stani_nes
stannites947013stannit_es
sties55132983s___ties
stimies9316563s_timies
stithies1139233s_tithies
suites63727403s_uit_es
sundries9312023sundries
sureties8316583sureties
sweeties11159723sweeties
syenites1138943syenit_es
tanistries1047063tanistries
tansies74521243tan_sies
tantivies1247103tantivies
tatties74120343ta_tties
taxites1449673taxit_es
tensities9311333tensities
tenuities949763tenuities
trinities9313333trinities
unifies102714713_unifies
unites65024853_unit_es
unitizes1739133_unitizes
unties64326923_un_ties
uranites82514643uranit_es
urbanities1245323urbanities
vacuities1447143vacuities
vanishes141610753vanishes
vanitories1346903vanitories
varieties1259203varieties
varsities1239243varsities
vastities1248933vastities
verities111418043verities
vinifies1439873vinifies
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.186960704.3
2DLD Change Limit1461623867.18620339.8
3Display Results3863860.1562474.4
 (SQL Overall)1786913867.52823736.8
 
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.