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

59 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
concurrences155440(None) 
concurrence1454791concurrence_
concurrencies1653161concurrencies
concurrency1753422concurrenc_y
concurrents1554562concurren_ts
conferrences19106072conferrences
incurrences1555332_incurrences
occurrences1452772_occurrences
concordances16103683concordances
concurrent1446313concurren__t
concurrently1952883concurrently
conferences1898813con_ferences
conferrence1896563conferrence_
congruences1655013con_gruences
convergences20146253convergences
incurrence1455733_incurrence_
nonconcurrences1872143nonconcurrences
nonoccurrences1771923nonoccurrences
occurrence1353233_occurrence_
recurrences1544863_recurrences
reoccurrences1661713reoccurrences
coherences1787044co__herences
coincidences1683524coinc_idences
coinsurances1653014coinsu_rances
concordance15123914concordance_
concrescences15104344concrescences
concretes13411474conc__re_tes
concubines1645004concu_bin_es
concupiscences18161714concupiscences
concurred1445674concurr___ed
concurring1546604concurrin__g
condolences1655294con_dolences
conductances1653054conductances
conference1799004con_ference_
conferrees1546104conferre__es
confidences1946634con_fidences
confluences1855094con_fluences
conformances21104094conformances
congruence1555074con_gruence_
congruencies1753234con_gruencies
consciences1447024con_sciences
consequences2554844consequences
consistences1655424consistences
continences1588584con_tinences
contingences1794994contingences
conveniences1986314conveniences
convergence19116534convergence_
convergencies21143904convergencies
conversances1975714conversances
corpulences1754034corpu_lences
currencies1445664___currencies
fourpences1743984fo__urpences
insurgences1454624_insurgences
nonconcurrence1772614nonconcurrence_
noncurrent1255514noncurren__t
nonoccurrence1672184nonoccurrence_
occurrents1453004_occurren_ts
recurrence1445314_recurrence_
reoccurrence1561874reoccurrence_

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 Filter1786911247900.406440125.6
2DLD Change Limit124790596.28019871.0
3Display Results59590.0501180.0
 (SQL Overall)178691596.73626527.8
 
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.