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

109 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
comicalities184697(None) 
logicalities1555052logicalities
topicalities1655582topicalities
chiralities1646513c_hiralities
coequalities2355563coequalities
coevalities1646803co_evalities
comicality1946133comicalit__y
commonalities1965153commonalities
communalities1954843communalities
concavities1846123co_ncavities
conicities14412643conic__ities
cordialities1546153cordialities
criminalities1754743criminalities
criticalities1754683criticalities
cyclicalities1953033cyclicalities
ethicalities1754443ethicalities
jovialities2145163jovi_alities
lexicalities2154723lexicalities
localities1259733lo__calities
musicalities1655823musicalities
socialities1349293soci_alities
typicalities1954153typicalities
vocalities1549393vo__calities
admiralties1452094admiral_ties
amicabilities19197914_amicabilities
amoralities1347424_amoralities
animalities1348994_animalities
atomicities1545954atomic__ities
atypicalities2052684atypicalities
axialities1747734_axi_alities
bimodalities1753944bimodalities
cardinalities1654394cardinalities
carnalities1348784c_arnalities
causalities1346224c_ausalities
centralities1448624centralities
chicalotes17163564c_hicalot_es
civilities1547844c__ivilities
classicalities1862534classicalities
clonicities1546184clonic__ities
coalifies1439114co___alifies
codicologies1853674codicologies
coercivities1954244coercivities
coilabilities1748094co_ilabilities
colinearities1553714colinearities
comities12317794com____ities
commercialities2363314commercialities
commodities1845494com_modities
commonalties1854254commonal_ties
communities1747274com_munities
complexities25113834complexities
complicities2055964complicities
concinnities1654414concinnities
conjugalities2353004conjugalities
convivialities2262774convivialities
corporalities1755294corporalities
cubicities1646824cubic__ities
docilities1349004do__cilities
domiciliates1751574domiciliates
efficacities2252194efficacities
farcicalities2053574farcicalities
finalities1349914__finalities
formalities16137824fo_rmalities
genialities12148644geni_alities
hospitalities1854124hospitalities
humilities1547704humi__lities
iconicities1556664iconic__ities
illogicalities17132524illogicalities
immoralities1655734immoralities
ionicities12410034ionic__ities
jovialties2042344jovi_al_ties
labialities1347034labi_alities
localites111210434lo__calit_es
mammalities1444854mam_malities
minacities1447994__minacities
mobilities1449834mobi__lities
modalities13138814__modalities
molalities121110284__molalities
moralities121111924__moralities
mortalities1348424mo_rtalities
motilities12410584moti__lities
nobilities12410644nobi__lities
nodalities11138584no__dalities
normalities13148114no_rmalities
notionalities1355924notionalities
optimalities1654664optimalities
oralities91214124_o__ralities
osmolalities1454174osmolalities
ovalities12119804_o__valities
oviparities1654294_oviparities
physicalities2393644physicalities
primalities1548294_primalities
prodigalities1763934prodigalities
rascalities1347224_rascalities
similarities1454224similarities
socialites1247504soci_alit_es
sodalities11138704so__dalities
solidarities1354274solidarities
specialities1656794specialities
spiralities1348014_spiralities
technicalities2161954technicalities
tonalities101711734to__nalities
tonicities12410364tonic__ities
totalities101210784to__talities
toxicities1947284toxic__ities
unmoralities1485564unmoralities
venialities14168934veni_alities
verticalities1885214verticalities
vitalities1349094__vitalities
whimsicalities2461734whimsicalities

Search took 9 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.406440125.6
2DLD Change Limit1247901097.57616471.8
3Display Results1091090.0801362.5
 (SQL Overall)1786911098.06222164.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.