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

84 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
congruences165501(None) 
congruence1555071congruence_
congruencies1753231congruencies
confluences1855092confluences
congruency1853552congruenc_y
incongruences1863522incongruences
coherences1787043coher_ences
concurrences1554403concurrences
condolences1655293condolences
conferences1898813conferences
conferrences19106073conferrences
confidences1946633confidences
confluence1755333confluence_
congresses1348023congr_esses
congruent1247413congruen__t
congruently1753513congruently
congruities1455193congruities
consciences1447023consciences
consequences2554843consequences
continences1588583continences
convergences20146253convergences
incongruence1763613incongruence_
clarences1346454c_lar_ences
coagencies1545624coag__encies
cogencies1448104co_g__encies
cognizances2552504cognizances
coherence1676934coher_ence_
coherencies1884774coher_encies
coincidences1683524coincidences
coinsurances1653014coinsurances
commences17139584co__mmences
competences1956374competences
concordances16103684concordances
concrescences15104344concrescences
concretes13411474concr_e_tes
concurrence1454794concurrence_
concurrencies1653164concurrencies
condenses12710134con__denses
condolence1565314condolence_
conduces13129784con_du__ces
conference1799004conference_
conferrence1896564conferrence_
confidence1847064confidence_
confluents1545414confluen_ts
conformances21104094conformances
confreres1448034confr_e_res
congees103517924cong__e__es
congener112412204cong__en_er
congeners122511134cong__eners
congeries12316404cong__eries
congregates1545504congregates
congress1138074congr_e__ss
congressed1445464congr_essed
congruous1244344congru__ous
conjuncts2043654con_ju_ncts
connivances1854184connivances
conscience1347054conscience_
consequence2455014consequence_
consistences1655424consistences
consonances1545774consonances
continence1489134continence_
contingences1794994contingences
continuances1654684continuances
contravenes1655634contraven_es
contrivances1954134contrivances
convalesces1853124convalesces
convenes132916914con__ven_es
conveniences1986314conveniences
convergence19116534convergence_
convergencies21143904convergencies
conversances1975714conversances
conveyances2185204conveyances
convinces1647834con__vinces
coprinces1547484co_pr_inces
corpulences1754034corpulences
covalences1745834co_valences
covariances1853734covariances
fourpences1743984fo_urpences
gangrenes1145064gangr_en_es
influences1545654_influences
nonfluencies1753214nonfluencies
nonsciences1556094nonsciences
occurrences1452774occurrences
tangences1246444tang__ences

Search took 10 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 Filter1786911488190.1701051123.5
2DLD Change Limit148819849.65615412.1
3Display Results84840.0461826.1
 (SQL Overall)178691849.87218100.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.