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

76 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
discordancies196261(None) 
discordances1853681discordanc_es
discordance1753962discordanc_e_
discordancy2052673discordanc__y
discrepancies2061773discrepancies
absorbancies1852194abs_orbancies
accordances1553194_accordanc_es
ascendancies17112624_ascendancies
concordances16103684concordanc_es
despondencies1962144despondencies
disbranches1953524dis_br_anches
discographies2284584discographies
discordant1445424discordan___t
discordantly1962364discordan_tly
disorganizes2353354dis_organizes
dissonances1454274disso_nanc_es
disturbances1752454disturbanc_es
dormancies1565414d___ormancies
importancies1853274_importancies
isocracies1444974_isocr_a_cies
mordancies1544704___mordancies
absorbances1752935abs_orbanc_es
absorbencies1852145abs_orbencies
accordance1453355_accordanc_e_
ascendances16123835_ascendanc_es
ascendencies17103085_ascendencies
concordance15123915concordanc_e_
decadencies1753875d_ec_adencies
democracies1864305democr_a_cies
despondences1853395despondenc_es
diachronies1754035diachr_on_ies
dilatancies1453255di__latancies
diplomacies1853145diplo_ma_cies
disarranges1363855dis_arran_ges
disbranched2052805dis_br_anched
discardable1753465discarda_ble_
discontinues1564395discontin_ues
discorded1438135discord____ed
discording1547665discord___ing
discords1238595discord_____s
discourages1554385discoura__ges
discourtesies1672265discourtesies
discoveries1745805disco__veries
disfranchise2162235dis_fr_anchise
disfranchises2262095dis_fr_anchises
disgraces1348455dis_gr_a_c_es
disharmonies1852475disharmon_ies
disloyalties1661685dislo_yalties
disorganize2253665dis_organ_ize
disorganized2452965dis_organized
dissidences15164135dis_sidenc_es
dissonance1354415disso_nanc_e_
distances12311655dis___tanc_es
disturbance1662705disturbanc_e_
divergencies1963575di_vergencies
episcopacies2061715episco_pa_cies
ignorances1344335_ignor_anc_es
importances1754295_importanc_es
incessancies1652855_incessancies
inconstancies1763395_inconstancies
inerrancies1355045_i_nerrancies
isostacies1244435_is_osta_cies
mesocranies1554065mesocr_an_ies
miscellanies1652545miscellan_ies
mischances1946375misc__hanc_es
misguidances1861655misguidanc_es
necromancies1853685_necromancies
oscitancies1552885_osc_itancies
recreancies1544655_rec_reancies
sycophancies2452475_sycophancies
timocracies1753245timocr_a_cies
verdancies1645235___verdancies
vibrancies1744415vi__br_ancies
vicariances1852895vi_carianc_es
viscountcies1962085visco_untcies
viscounties1653635visco__unties

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 Filter1786911247900.390458182.1
2DLD Change Limit124790768.90614011.9
3Display Results76760.0461652.2
 (SQL Overall)178691769.34219127.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.