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

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

63 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
noncoincidences19161651noncoincidences_
noncoincidence18171812noncoincidence__
nonconfidences22103143nonco_nfidences_
coincidences1683524___coincidences_
nonconfidence21103514nonco_nfidence__
coincidence1583605___coincidence__
nonconcurrences1872145nonco_ncurrences_
confidences1946636___co_nfidences_
incidences1547136_____incidences_
incontinences17175466_inco_ntinences_
noncompliances2262426noncompli_ances_
nonconcurrence1772616nonco_ncurrence__
nonconference2074196nonco_nference__
nonconfidential2172066nonco_nfidential
nonevidences1853806non___evidences_
noninfluences1882906non__influences_
nonresidences1663766non__residences_
nonsciences1556096non___sci_ences_
accidences1444407__ac___cidences_
antisciences1653367_an_tisci_ences_
coincident1554567___coinciden___t
coincidental1762437___coinciden_tal
coincidently2062827___coinciden_tly
coincides1446437___coincid___es_
conciseness1546667___co_ncisen_ess
concomitances1862787conco__mitances_
concordances16103687conco___rdances_
concrescences15104347concresc__ences_
concupiscences18161717concupisc__ences_
confidence1847067___co_nfidence__
consciences1447027___consci_ences_
continences1588587___co_ntinences_
contingences1794997con_tin__gences_
conveniences1986317con_ven_i_ences_
convincingness2271347con_vincingn_ess
incidence1447607_____incidence__
incipiences1755167_inc_i_pi_ences_
incognizances2762297_incogn_izances_
incongruences1863527_inco_ngruences_
inconsistences1883727_inco_nsistences_
incontinence16135647_inco_ntinence__
incontinencies18163757_inco_ntinencies_
neurosciences1762647neuro_sci_ences_
noncandidacies2071447nonc_andidacies_
noncandidates1762607nonc_andid_ates_
noncitizens2252607nonc_i_tizen__s_
noncompliance2162847noncompli_ance__
nonconcerns1554497nonco_nc__e_rns_
nonconformances24202867nonconformances_
noncontingent1673357nonco_nti__ngent
nonevidence1754087non___evidence__
nonexistences22112957nonexi__stences_
nonindigenous15121457non__indigenous_
noninfluence1783197non__influence__
nonjoinders1952777nonjoin__de__rs_
nonoccurrences1771927non_occurrences_
nonresidence1554147non__residence__
nonresidencies1762527non__residencies_
nonscience1456237non___sci_ence__
nonsentences1455717non_sen__tences_
nonviolences1753287non_vi__olences_
omnisciences1862447_o_mnisci_ences_
overconfidences2672117overco_nfidences_

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 Filter178691950240.360496363.9
2DLD Change Limit95024638.31011434.9
3Display Results63630.0461369.6
 (SQL Overall)178691638.71620501.5
 
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.