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

40 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
nonequivalences29171231nonequivalences_
nonequivalence28161262nonequivalence__
equivalences2672294___equivalences_
nonequivalent2591564nonequivalen___t
equivalence2552385___equivalence__
equivalencies2761495___equivalencies_
equivalency2861846___equivalenc__y
equivalents2352586___equivalen_ts_
nonevidences1853806none___vidences_
nonexistences22112956none_xi_stences_
nonviolences1753286non__vi_olences_
ambivalences2191977___ambivalences_
benevolences1961807bene___volences_
bivalences17104347_____bivalences_
conceivableness24102337con_ceivablen_ess
connivances1854187con__niva__nces_
consequences2554857consequ____ences_
contrivances1954137con_triva__nces_
convalesces1853127con____valesces_
covalences1745837co_____valences_
divalences16114777_____divalences_
equipollences26151257___equipollences_
equitableness24105477___equitablen_ess
equivalent2253217___equivalen___t
equivalently2761867___equivalen_tly
inequivalve266767_inequival__ve__
inequivalved286577_inequival__ve_d
multivalences2062847__multivalences_
nonchalances19172687non___chalances_
nonequals1844597nonequ__al____s_
nonequilibria2471367nonequi__l_ibria
nonevidence1754087none___vidence__
nonexistence21173527none_xi_stence__
noninfluences1882907non___influences_
nonresidences1663767nonresi__dences_
nonsciences1556097non_sci___ences_
nonsensicalness1771377nonsensical_n_ess
nonviolence1653437non__vi_olence__
polyvalences2271927po___lyvalences_
prevalences1845097_pre___valences_

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 Limit95024408.11011716.9
3Display Results40400.0301333.3
 (SQL Overall)178691408.50021022.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.