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

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

48 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
equivalencies276149(None) 
equivalences2672291equivalenc_es
equivalence2552382equivalenc_e_
bivalencies18112873__bivalencies
equivalency2861843equivalenc__y
equivalents2352583equivalen__ts
ambivalences2191974ambivalenc_es
bivalences17104344__bivalenc_es
covalencies1853994__covalencies
divalences16114774__divalenc_es
equipollences26151254equipollenc_es
equivalent2253214equivalen___t
equivalently2761864equivalen_tly
nonequivalences29171234nonequivalenc_es
valencies1446414____valencies
ambivalence2072095ambivalenc_e_
bivalence16124605__bivalenc_e_
covalences1745835__covalenc_es
divalence15135095__divalenc_e_
ebulliencies1651785ebu_lliencies
efficiencies2252525effi_ciencies
eminencies1445935e_mi__nencies
equalities1949015equ__al_ities
equipollence25101315equipollenc_e_
equitableness24105475equitablen_ess
equitablenesses26104355equitablenesses
equivocalities28112075equivocal_ities
equivocalnesses2971215equivocalnesses
esuriencies1353825esu__riencies
excellencies2351995e_xcellencies
exigencies2045265e_xi__gencies
exultancies20142455exulta__ncies
multivalences2062845multivalenc_es
nonequivalence28161265nonequivalenc_e_
opulencies1443565opu___lencies
polyvalences2271925polyvalenc_es
prevalences1845095_prevalenc_es
purulencies1553575_pu_rulencies
quiescences2454215_quiescenc_es
sequencies2155995sequ____encies
squalenes1845765squ__alen__es
subagencies1653485_su_bagencies
subjacencies2552275_subjacencies
truculencies1672175tru_culencies
turbulencies1651905_turbulencies
valences1388515____valenc_es
valencias1443635____valencias
virulencies1652955__virulencies

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 Filter1786911247900.390458182.1
2DLD Change Limit124790487.94015716.6
3Display Results48480.0133692.3
 (SQL Overall)178691488.34321418.1
 
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.