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

117 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
cordialities154612(None) 
cardinalities1654352cardinalities
carnalities1348763car_nalities
coequalities2355543coequalities
coevalities1646783co_evalities
comicalities1846953comicalities
cordiality1645613cordialit__y
cordierites1454053cordierit_es
corporalities1755283corporalities
formalities16137813for_malities
jovialities2145163jo_vialities
modalities13138813mo_d_alities
moralities121111923mor__alities
mordacities1644223mord_acities
mortalities1348413mor_talities
nodalities11138583no_d_alities
normalities13148103nor_malities
oralities91214113_or__alities
partialities14108033partialities
prodigalities1763933prodigalities
socialities1349283so_cialities
sodalities11138693so_d_alities
amoralities1347414amor__alities
auralities10410224aur__alities
axialities1747724__axialities
bestialities1455484bestialities
brutalities1345424_brutalities
cardinalates1552594cardinalat_es
cardiologies1644954cardiologies
cariosities1346464car_iosities
causalities1346204c_ausalities
centralities1448604centralities
chiralities1646504c_hiralities
civilities1547844c_ivi_lities
coalifies1439114co___alifies
coercivities1954234coerci_vities
collegialities1763044collegialities
commercialities2363304commercialities
commonalities1965134commonalities
communalities1954824communalities
concavities1846114co_ncavities
concinnities1654404concinnities
congenialities1774194congenialities
conicities14412624co_ni_cities
conjugalities2353004conjugalities
connubialities1862594connubialities
contiguities1554444contiguities
continuities1456224continuities
convivialities2262774convivialities
cordialness1444764cordial_ness
cordialnesses1654554cordialnesses
cordials1139604cordial____s
cordierite1354574cordierit_e_
cordites11314604cord___it_es
corporealities1863204corporealities
corporeities1654274corporeities
corydalises1753354corydali_ses
credibilities1856064credibilities
credulities1444114c_redulities
criminalities1754734criminalities
criticalities1754674criticalities
curabilities1649384curabilities
curiosities1344974cur_iosities
cyclicalities1953034cyclicalities
docilities1349004do_ci_lities
dualities10310444___dualities
erodibilities1656884erodibilities
farcicalities2053574farcicalities
fertilities1448814ferti_lities
feudalities1545344feud_alities
frontalities1555554frontalities
frugalities1544154_frugalities
genialities12148644_genialities
hospitalities1854124hospitalities
hostilities14127644hosti_lities
idealities1148774__idealities
irrealities1146204_irrealities
jovialties2042344jo_vial_ties
labialities1347034_labialities
localities1259734lo__calities
logicalities1555054logicalities
marginalities1654324marginalities
mobilities1449834mo_bi_lities
molalities121110284mo__lalities
morbidities1644604morbi_dities
motilities12410584mo_ti_lities
nobilities12410644no_bi_lities
nuptialities1454784nuptialities
optimalities1654664_optimalities
originalities1464884_originalities
ovalities12119804_o__valities
primalities1548284_primalities
realities9316304__r_ealities
regalities11410584__regalities
ruralities1048564__ruralities
scurrilities1452704scurri_lities
servilities1447054servi_lities
socialites1247504so_cialit_es
sodalites10128694so_d_alit_es
solidarities1354274solidarities
spatialities1465554spatialities
specialities1656774specialities
tonalities101711734to__nalities
topicalities1655584topicalities
torpidities1444804torpi_dities
torridities1244494torri_dities
totalities101210764to__talities
trivialities1555214trivialities
unrealities1147534unr_ealities
venialities14168934_venialities
veridicalities2063064veridicalities
verticalities1885214verticalities
virilities1379124vir_i_lities
virtualities1554694virtualities
vocalities1549394vo__calities
voracities1547064vor__acities
vorticities1647084vorti_cities

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 Filter1786911247900.1401276364.3
2DLD Change Limit1247901177.37616918.4
3Display Results1171170.0601950.0
 (SQL Overall)1786911177.57623586.5
 
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.