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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
discontentments207300(None) 
discontentment1963611discontentment_
disconcertments2282492disconcertments
contentments1655483___contentments
disconcertment2163003disconcertment_
contentment1556664___contentment_
discontented1655314discontent_e__d
discontentedly2182684discontent_edly
discontenting1755084discontent_in_g
discontents1447564disco___nt_ents
disinterments1664864dis_inte_rments
disinvestments2063034dis_investments
disappointments22111995disappointments
disburdenments2062505disburden_ments
discernments1785195disc___ernments
disconnections1954025disconnection_s
disconnects1654115discon__n__ects
discontent13410255disco___nt_ent_
discontinues1564405discontin_ue__s
discouragements21182815discouragements
disenchantments2391975disenchantments
disheartenments21242645dishearten_ments
disinterment1565875dis_inte_rment_
disinvestment1963485dis_investment_
dislodgements18103455dislodge__ments
dismantlements19103025dismant_lements
disownments17114905dis_o__wn_ments
disportments1755355dispo___rtments
dissentients1354225dis___sentients
intendments1455705_i___ntendments
accouterments1992066_accoute_rments
cantonments1554426___canton_ments
concealments1854076___concealments
concernments1865246___concernments
conferments1848326___confe_rments
confinements1954946___confinements
congealments1753296___congealments
containments1655786___containments
contentions13412096___contention_s
contestants1356806___contest_ants
continents1249566___contin__ents
contingents1446376___contin_gents
controlments1684446___controlments
decongestants1771896d_econgest_ants
denotements1446866d_eno_te__ments
descendents1554146desc___en_dents
devotements1745616d_evo_te__ments
disablements1754916dis_able__ments
disagreements1763656dis_agre_ements
disappointment2192186disappointment_
disbandments1853446dis___bandments
disburdenment1962716disburden_ment_
disbursements1853916disburse__ments
discernment16116126disc___ernment_
discommends1962776disco____mmends
disconcerted1854346disconcert_e__d
disconcerting1954586disconcert_in_g
disconcerts1655246disco___n_certs
disconnect1555876discon__n__ect_
disconnected1853716disconnect_e__d
disconnectedly2371646disconnect_edly
disconnecting1953886disconnect_in_g
disconnection1854206disconnection__
discontinuance19162526discontin_uance
discontinuances20142246discontinuances
discontinue1455246discontin_ue___
discontinued1654036discontin_ue__d
discontinuing1783256discontin_uin_g
discontinuities1872186discontinuities
discontinuity1962966discontin__uity
discontinuous1672556discontin__uous
discountenance19122226discounten__ance
discountenances20122236discounten_ances
discounters1445766disco__unt_e_rs
discouragement20162926discouragement_
discreteness1554486discreten__e_ss
disenchantment2292146disenchantment_
disendowments20112996dis_en_dowments
disengagements19163426dis_engagements
disgruntlements19112046disgrunt_lements
disguisements1763936disguise__ments
disheartenment20202906dishearten_ment_
dishonesties1652676dishon_estie__s
disinfectants1972376dis_infect_ants
disinfestants1772486dis_infest_ants
disinterests1353136dis_inte__rests
dislodgement1783956dislodge__ment_
dislodgments1783216dislo___dgments
dismantlement1883506dismant_lement_
dismemberments2072176dismembe_rments
disownment16115836dis_o__wn_ment_
displacements2053896displace__ments
disportment1656656dispo___rtment_
dissentient1256956dis___sentient_
dissepiments1753466dis___sepiments
disseverments19123186dis_seve_rments
distentions12178866dis___tention_s
divestments17155166di____vestments
divorcements2054416di_vorce__ments
dizenments2244976di____zen_ments
incitements1556296_inc_ite__ments
incompetents1854576_incompe_t_ents
incontinent1357106_incontin__ent_
inconvenient1764986_inconven_ient_
integuments1454566_i___nteguments
intendment1347176_i___ntendment_
interments12716216_i___nte_rments
internments13510286_i___nternments
investments1665906_i___nvestments
misconceptions2263586misconception_s
misconnections2063816misconnection_s
misconnects1753266miscon__n__ects
misgovernments2271976misgo_vernments
misstatements17122906misstate__ments
mistreatments1762786mis__treatments
nontreatments1563296___nontreatments
resentments1346546res____entments
subcontinents1772666subcontin__ents

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 Limit950241188.34311389.7
3Display Results1181180.0931268.8
 (SQL Overall)1786911188.79620315.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.