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

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

48 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
concordances1610368(None) 
concordance15123921concordance_
conformances21104092conformances
accordances1553193_accordances
concomitances1862783concomitances
concordant1545743concordan__t
concordantly2051953concordantly
concordats1544193concorda__ts
concurrences1554403concurrences
conformance20114473conformance_
consonances1545773conso_nances
conversances1975723conversances
discordances1853683discordances
accordance1453354_accordance_
chlordanes1644514c_hlordan_es
coincidences1683524coinc_idences
coinsurances1653014coinsur_ances
concomitance1763084concomitance_
concordal1445324concorda___l
concordat1446354concorda___t
concords1358594concord____s
concurrence1454794concurrence_
concurrencies1653164concurrencies
condolences1655294condo_lences
conductances1653054conductances
conferences1898814confer_ences
conferrences19106074conferrences
confidantes1754144con_fidantes
confidences1946634con_fidences
congruences1655014con_gruences
connivances1854184con_nivances
conservancies2054114conservancies
consonance1446184conso_nance_
consonancies1653924conso_nancies
continuances1654684continuances
contredanses1552884contredanses
contrivances1954134contrivances
convergences20146254convergences
conversance1876324conversance_
conversancies2053594conversancies
conveyances2185204con_veyances
covariances1853734co_variances
discordance1753964discordance_
discordancies1962614discordancies
ignorances1344344ign_or_ances
monstrances1545014monstr_ances
nonchalances19172684nonchalances
nondances1247804__n_ondances

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.390458182.1
2DLD Change Limit124790487.39016886.3
3Display Results48480.0163000.0
 (SQL Overall)178691487.79622920.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.