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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
colloquialities267188(None) 
collegialities1763043coll_egialities
colloquialisms2771763colloquiali_sms
colloquiality2761763colloquialit__y
coequalities2355564co__equ_alities
collateralities17152334collateralities
colloquialism2672064colloquial__ism
colloquials2252394colloquial____s
cellularities1562405cell__ularities
coilabilities1748095coil_abi_lities
collectivities2174165collecti_vities
collinearities1662175coll_inearities
colloquial2153075colloquial_____
colloquially2691965colloquial___ly
colloquies2144095colloqu_____ies
colloquists2253005colloqui__st__s
colonializes2354395co_lo_niali_zes
commercialities2363315commercialities
commonalities1965155commo__nalities
communalities1954845co__mmunalities
congenialities1774195co_ngenialities
conjugalities2353005co__njugalities
connaturalities17162605connaturalities
connubialities1862595co_nnubialities
convivialities2262775co_nvivialities
cordialities1546135c___ordialities
corporalities1755295corpo__ralities
corporealities1863205corpo_realities
illiquidities2361495_illiqui_dities
illogicalities17132525_illogicalities
loquacities2252905___loqu_acities
callosities1345086callo____sities
causalities1346226c____ausalities
cellulites1294436cell__u__lit_es
cellulitis12122946cell__u__liti_s
cellulitises1452086cell__u__litises
chlorinities1754186c_hlo_ri_nities
classicalities1862536c_lassicalities
clonicities1546186c__lo_ni_cities
coevalities1646806c___o_evalities
colinearities1553716co_l_inearities
collateralizes2572486collaterali_zes
collegiality1863226coll_egialit__y
collocates1448126collo__ca__t_es
colloquia2053396colloquia______
colloquist2154216colloqui__st___
colloquiums2452086colloqu___i_ums
colonialisms1674756co_lo_niali_sms
colonialistic1773186co_lo_nialisti_c
colonialists1484996co_lo_niali_sts
colonialize2254626co_lo_niali_ze_
colonialized2453636co_lo_niali_zed
colonializing2553606co_lo_nializing
comicalities1846976c___omicalities
commonalties1854256commo__nal_ties
conceptualities2174296conceptualities
coplanarities1752666copl__anarities
corequisites2351446co_requi_sit_es
countabilities1856696countabi_lities
culpabilities1946026c_ulpabi_lities
cyclicalities1953036cycl__icalities
equalities1949016____equ_alities
fallibilities1854546fall_ibi_lities
folliculitis1761156follicu__liti_s
folliculitises1961256follicu__litises
gullibilities1653766gull_ibi_lities
homosocialities2292066homosocialities
illegalities1353886_ill__egalities
illiberalities1662446_illiberalities
inequalities2156146__inequ_alities
jovialities2145166___jo_vialities
labialities1347036___l_abialities
liquidities2144186___liqui_dities
localities1259736___lo__calities
logicalities1555056___logicalities
lognormalities1761706logno_rmalities
malleabilities1874976malleabi_lities
molalities121110286mo_l____alities
nonmotilities1555136nonmo_ti_lities
notionalities1355926notio__nalities
obliquities2252656_obliqu___ities
osmolalities1454176_osmo__lalities
pluralities1345686__pl__uralities
polytonalities1982746po_lytonalities
potentialities1674206po_tentialities
qualities18311226_____qu_alities
socialities1349296___so_cialities
solubilities1446006so_l__ubilities
solvabilities1846896so_lvabi_lities
tolerabilities16116606tolerabi_lities
tranquilities2253906_tranqui_lities
tranquillities2362466_tranquillities
volatilities1546516vo_l_ati_lities
volubilities1745126vo_l__ubilities

Search took 7 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 Filter178691950240.360496363.9
2DLD Change Limit95024946.39314863.8
3Display Results94940.0601566.7
 (SQL Overall)178691946.81326227.9
 
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.