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 “posterities” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

152 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
posterities136903(None) 
austerities1145712austerities
prosperities1655482prosperities
alterities10411043_alterities
asperities1249763_asperities
dexterities1945813dexterities
esterifies1347153_esterifies
hostilities14127653hostilities
osteitides1143963_oste_itides
osteitis847013_oste_iti_s
paternities1345783p_aternities
polarities121211773po_larities
positivities1755453positivities
postcrisis1454903postcrisi_s
postediting1554453postediting
posteriorities1661853posteriorities
posteriors1256813posteri_ors
posterity1448693posterit__y
potteries11313593potter__ies
poverties1439513po_ver_ties
preterites12411793preterit_es
arteritides1254694_arteritides
arteritis949754_arteriti_s
austenites1044964austenit_es
booteries11312774booter__ies
celerities1289774_celerities
convexities2354564convexities
coprosperities2071954coprosperities
coteries10422704co_ter__ies
disparities1446794disparities
dolerites101410894do_lerit_es
easterlies1046714easter_lies
elaterites1048274elaterit_es
enteritides1245844_enteritides
enteritis9411304_enteriti_s
enteritises1147724_enteritises
esterified1445404_esterified
eternities1048064__eternities
ferities111416714___ferities
festivities1746584festivities
fortuities1346324fort_uities
fosterages1444774foster_ages
fraternities1552944fraternities
futurities1345424_futurities
gaseities1047084gas_e_ities
gastritides1353084gast_ritides
gastritis1045674gast_riti_s
gastritises1253574gast_ritises
ghostwrites1852024ghostwrit_es
hosieries1249214hosier__ies
hostelries1345424hoste_lries
integrities1247784_integrities
interties9320334_inter_ties
inverities13410624_inverities
laterites9715054_laterit_es
legerities1196884_legerities
listerioses1153754listerioses
longevities1553054longevities
lotteries9311074lotter__ies
masteries111018494master__ies
maternities1346014_maternities
maturities1248454_maturities
modernities1444634mo_dernities
molarities12129434mo_larities
mortalities1348424mortalities
motilities12410584mo_tilities
motivities1547694mo_tivities
mysteries141211194myster__ies
nonparities1348584nonparities
notorieties1153854no_torieties
obesities1145844_o_besities
obscenities1552834obscenities
obscurities1553214obscurities
obtusities1253824_obtusities
osteitic1046944_oste_iti_c
ostriches1446634_ost_riches
outcities1149514_out_cities
outpities1148624_out_pities
outwrites1238234_outwrit_es
parities10522974p___arities
passerines1246164passeri_nes
passivities1644904passivities
pasteurises1343954pasteuri_ses
pasteurizes2243664pasteuri_zes
pastorates12410144pastorat_es
pastries101517424past_r__ies
perversities1754454perversities
petrifies14310364p_et_rifies
piosities11311724pios___ities
planarities1345324planarities
plasticities1655554plasticities
poetries10315584poet_r__ies
polities102722344po___lities
pomposities1765714pomposities
poperies12316794po_per__ies
popularities1674684popularities
porosities12411484po_rosities
porterages1345974porter_ages
porteresses1345524porteresses
positives1459174pos___itives
postdates1248864post_dat_es
posterior1147834poster__ior
posteriority1762364posteriority
posteriorly1652674posteriorly
posterns102713724poster___ns
posters93928014poster____s
posteruptive1962224posteruptive
postexilic2152334postexili_c
postfixes2164474post_fi_xes
posthastes1546274posthast_es
postiches1648224post__iches
posties93128814pos____ties
postiques2045834post__iques
postrider1246654post_ri_der
postriders1344854post_riders
postulates1268964postulat_es
postures10313784postur___es
posturists1247074posturi_sts
potencies1369304po_te_ncies
potties93723544po_t___ties
presterilizes24103274presterilizes
preterite11613204preterit_e_
preterits11410964preterit__s
priorities1249154p_riorities
properties141411884proper_ties
prostatitis1355864prostatiti_s
prostatitises1553824prostatitises
prostrates12411994prost_rat_es
pteridines1345464p__teridines
puberties1346604p_uber_ties
purities10316284p___urities
quaternities2152504quaternities
roseries8317314ros_er__ies
rusticities1346844rusticities
severities1348514_severities
sincerities1347094sincerities
sonorities10910654so_norities
sororities10109194so_rorities
spasticities1654624spasticities
sterilise948994__sterilise
sterilises1048254__sterilises
sterilities11129014__sterilities
sterilizes1947644__sterilizes
sternites9310074__sternit_es
temerities1268484_temerities
totalities101210784to_talities
totemites1146604to_temit_es
vastities1248934vast__ities
verities111418044___verities
vorticities1647084vorticities
wasteries121115344waster__ies
westerlies1345614wester_lies

Search took 10 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 Filter1786911488190.420425454.8
2DLD Change Limit1488191528.69017125.3
3Display Results1521520.0762000.0
 (SQL Overall)1786911529.18619452.5
 
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.