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

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

79 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
concomitances186278(None) 
concomitance1763081concomitance_
concomitants18103452concomitan_ts
concomitant17115293concomitan__t
concomitantly2261663concomitantly
concordances16103683conco_rdances
chrominances2152424c_hrominances
circumstances1862294circumstances
concordance15123924conco_rdance_
conductances1653054con_ductances
conformances21104094confo_rmances
connivances1854184con__nivances
conominees1445924con_omi__nees
consonances1545774conso__nances
contrivances1954134con_trivances
noncompliances2262424noncompliances
oscitances14104244_osc__itances
capacitances1751945c_apacitances
chrominance2052655c_hrominance_
circumstance1762625circumstance_
circumstanced1971835circumstanced
codominants1652895co_dominan_ts
cofinances1745305___cofinances
cognizances2552505co__gnizances
coincidences1683525coinc__idences
complaisances2161715complaisances
compliances1945035co_mpli_ances
concavities1846125concavit__ies
conceptacles1773795conc_eptacles
conciliates1546885concili_a_tes
concoctions1448255concoction__s
concrescences15104345concrescences
concubinages1951815concubina_ges
concubines1645005concubi__n_es
concupiscences18161715concupiscences
concurrences1554405conc_urrences
condolences1655295condo__lences
conductance1553405con_ductance_
confidantes1754145con__fidantes
confidences1946635con__fidences
conformance20114475confo_rmance_
conformities1954925conformit__ies
connivance1754255con__nivance_
conominee1348165con_omi__n_ee
consciences1447025con_sci_ences
consistences1655425con_sistences
consociates1546545consoci_a_tes
consolidates1563865consolida_tes
consonance1446185conso__nance_
consonancies1653925conso__nancies
constancies1546645con___stancies
consultancies1782655con_sultancies
contaminants1693955contaminan_ts
contaminates1656315contamina_tes
continences1588585con__tinences
continuances1654685con_tinuances
contrivance1854265con_trivance_
conveniences1986315conveni_ences
conversances1975725con_versances
conveyances2185205con__veyances
convinces1647835con__vi__nces
covariances1853735co_vari_ances
dominances1545685___dominances
encumbrances20152045_encumbrances
incognizances2762295_incognizances
incompetences21154525_incompetences
inconstancies1763395_inconstancies
inheritances1753925_inheritances
nonacceptances1971135nonacceptances
nonchalances19172685nonc_halances
noncombatants1961935noncombatan_ts
noncompliance2162845noncompliance_
nonconfidences22103145nonconfidences
nonresistances1662195nonresistances
oncomings1444235_oncomi__n_gs
oscitance13124475_osc__itance_
oscitancies1552885_osc__itancies
precipitances2163095precipitances
predominances2093295predominances

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.376475242.0
2DLD Change Limit124790798.07615452.0
3Display Results79790.0461717.4
 (SQL Overall)178691798.49821027.4
 
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.