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

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

143 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
counterviolence2271561counterviolence_
counterevidence2391584counterevi_dence_
counterbalance20123245counter_balance_
counterbalanced22142575counter_balanced
counterbalances21122825counter_balances
antiviolence1761846__ant_iviolence_
counterforce1985796counter_fo__rce_
counterforces2085556counter_fo__rces
counterinstance19101796counterinstance_
counterion1249536counter_io__n___
counterions1349826counter_io__n__s
countermine1549746countermi___n_e_
countermines1649156countermi___n_es
counterpicketed2671626counterpicke_ted
counterplea1547036counter__pl___ea
counterpointed1953596counter_po_inted
counterproject2763196counterproje_c_t
counterprojects2862156counterproje_cts
countersigned1784356countersi__gn_ed
countertendency2371926countertendenc_y
countervailed19154896countervail___ed
countervailing2063736countervailin__g
counterview19116686countervi_____ew
counterviews20134876countervi__e__ws
nonviolence1653436no_n___violence_
nonviolences1753286no_n___violences
ultraviolence1881766__ultraviolence_
ultraviolences1971586__ultraviolences
benevolence1861867_ben_e_v_olence_
benevolences1961807_ben_e_v_olences
centerpiece1762517c_enterpi__e_ce_
centerpieces1852547c_enterpi__e_ces
condolence1565317co_n____dolence_
condolences1655297co_n____dolences
conference1799017co_nfer____ence_
conferences1898817co_nfer____ences
conferrence1896577co_nfer___rence_
conferrences19106077co_nfer___rences
continence1489137co_nt___i_nence_
continences1588587co_nt___i_nences
contingence16105457co_nt___ingence_
contingences1794997co_nt___ingences
contrivance1854267co_nt_r_i_vance_
contrivances1954137co_nt_r_i_vances
convenience1886447co_nve_ni__ence_
conveniences1986317co_nve_ni__ences
convergence19116547co_nver___gence_
convergences20146257co_nver___gences
convertibleness2262637co_nvertibleness
convertiplane20131837co_nvertiplan_e_
convertiplanes21112127co_nvertiplan_es
countenance1555877counte____nance_
countenanced1754207counte____nanced
countenancer1654227counte____nancer
countenances1655737counte____nances
counteragent1557697counter__agen__t
counteragents1655177counter__agen_ts
counterblockade2671017counterblockade_
counterchange2194867counter__change_
counterchanged23103777counter__changed
counterchanges22124227counter__changes
countercheck2254117counter__che_c_k
counterchecked2562647counter__checked
counterchecks2353327counter__che_cks
counterclaimed2163527counter__claimed
counterculture1862327counter_culture_
countercultures1962237counter_cultures
countercurrent1863467countercurren__t
countercurrents1962337countercurren_ts
countercyclical2081077countercycl_ical
counterfeited1974777counter___feited
counterfeiter1874747counter___feiter
counterfire1647007counterfi____re_
counterfires1747067counterfi____res
counterfoil1655207counterfoil_____
counterfoils1755397counterfoil____s
counterimage1754987counter_i__mage_
counterimages1854617counter_i__mages
countering13314477counter_i___n__g
countermanded1974687counter___manded
countermelodies2092167counter_melodies
countermen1449297counter___men___
countermove1855857counter_mo___ve_
countermoved2054997counter_mo___ved
countermovement2471817counter_movement
countermoves1956017counter_mo___ves
countermoving2154167counter_movin__g
counteroffer2054117counter__o__ffer
counterorder1555617counter__o__rder
counterordered1862537counter__ordered
counterpane1549317counter___pan_e_
counterpanes1649307counter___pan_es
counterpicket2355167counterpi___cket
counterpickets2463317counterpicke__ts
counterplan1586777counter__plan___
counterplans1687147counter__plan__s
counterplayer2055047counter__pl_ayer
counterpleas1655807counter__ple__as
counterplotted1963417counter__plotted
counterpoint1658177counter_po_in__t
counterpoints1755627counter_po_in_ts
counterpoise1657357counter_po__ise_
counterpoised1855307counter_po__ised
counterpoises1756417counter_po__ises
counterpoising19164197counterpoisin__g
counterpose1547507counter_po___se_
counterposed1756327counter_po___sed
counterposes1647627counter_po___ses
counterposing1885447counter_posin__g
counterpower1965867counter_po___wer
counterpowers2064827counter_powe__rs
counterprotest1864437counterprote__st
counterprotests1962427counterprote_sts
counterpunch2154197counter___punc_h
counterpunched2492717counter___punched
counterpuncher2382637counter___puncher
counterpunches2383247counter___punches
counterrallied1763257counter_ral_lied
counterrallies1683957counter_ral_lies
counterresponse1961767counterresponse_
countersign1447247countersi__gn___
countersigning1863227countersi__gning
countersigns1546427countersi__gn__s
countersink1748067countersi___n__k
countersinking2163487countersinkin__g
countersinks1846167countersi___n_ks
counterstained1754847counter_stain_ed
counterstyle1755057counterstyl___e_
counterstyles1854787counterstyl___es
countertenor1454757counter___ten_or
countertenors1554067counter___tenors
countertrend1575947counter__tren__d
countertrends1674357counter__tren_ds
countervail1655657countervail_____
countervails1755997countervail____s
countrywomen2291947count_rywomen___
intermittence1772877__intermittence_
intermittences1872697__intermittences
nonevidence1754087no_n_e_vi_dence_
nonevidences1853807no_n_e_vi_dences
overviolent1754107_o__verviolen__t
subservience1962157_subservi__ence_
subserviences2061997_subservi__ences

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 Filter178691950240.343520965.0
2DLD Change Limit950241438.78010822.8
3Display Results1431430.1101300.0
 (SQL Overall)1786911439.23319353.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.