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

60 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
noncoincidences1916165(None) 
noncoincidence18171811noncoincidence_
nonconfidences22103142nonco_nfidences
coincidences1683523___coincidences
nonconfidence21103513nonco_nfidence_
coincidence1583604___coincidence_
nonconcurrences1872144nonco_ncurrences
confidences1946635___co_nfidences
incidences1547135_____incidences
incontinences17175465_inco_ntinences
noncompliances2262425noncompli_ances
nonconcurrence1772615nonco_ncurrence_
nonconference2074195nonco_nference_
nonevidences1853805non___evidences
noninfluences1882905non__influences
nonresidences1663765non__residences
nonsciences1556095non___sci_ences
accidences1444406__ac___cidences
antisciences1653366_an_tisci_ences
coincident1554566___coinciden__t
coincidental1762436___coincidental
coincidently2062826___coincidently
coincides1446436___coincid___es
concomitances1862786conco__mitances
concordances16103686conco___rdances
concrescences15104346concresc__ences
concupiscences18161716concupisc__ences
confidence1847066___co_nfidence_
consciences1447026___consci_ences
continences1588586___co_ntinences
contingences1794996con_tin__gences
conveniences1986316con_ven_i_ences
incidence1447606_____incidence_
incipiences1755166_inc_i_pi_ences
incognizances2762296_incogn_izances
incongruences1863526_inco_ngruences
inconsistences1883726_inco_nsistences
incontinence16135646_inco_ntinence_
incontinencies18163756_inco_ntinencies
neurosciences1762646neuro_sci_ences
noncandidacies2071446nonc_andidacies
noncandidates1762606nonc_andid_ates
noncitizens2252606nonc_i_tizen__s
noncompliance2162846noncompli_ance_
nonconcerns1554496nonco_nc__e_rns
nonconfidential2172066nonco_nfidential
nonconformances24202866nonconformances
nonevidence1754086non___evidence_
nonexistences22112956nonexi__stences
nonindigenous15121456non__indigenous
noninfluence1783196non__influence_
nonjoinders1952776nonjoin__de__rs
nonoccurrences1771926non_occurrences
nonresidence1554146non__residence_
nonresidencies1762526non__residencies
nonscience1456236non___sci_ence_
nonsentences1455716non_sen__tences
nonviolences1753286non_vi__olences
omnisciences1862446_o_mnisci_ences
overconfidences2672116overco_nfidences

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 Filter178691950240.356501941.0
2DLD Change Limit95024607.20613186.8
3Display Results60600.0302000.0
 (SQL Overall)178691607.59223536.7
 
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.