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

153 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
counterinstance19101791counterinstance_
countenance1555875counte__n__ance_
countenanced1754205counte__n__anced
countenancer1654225counte__n__ancer
countenances1655735counte__n__ances
counterbalance20123245counter_balance_
counterbalanced22142575counter_balanced
counterbalances21122825counter_balances
counterstained1754845counter__stained
counterstate1457035counter__sta_te_
counterstated1665645counter__sta_ted
counterstates1586645counter__sta_tes
continuance1555126co_nt__in_uance_
continuances1654686co_nt__in_uances
contrivance1854266co_nt_ri__vance_
contrivances1954136co_nt_ri__vances
conversance1876326co_nver__s_ance_
conversances1975726co_nver__s_ances
countenancers1752986counte__n__ancers
counterattack2172736counter_atta_c_k
counterattacked2471956counter_attacked
counterattacker2371796counter_attacker
counterattacks2272256counter_atta_cks
counterchange2194866counter__change_
counterchanged23103776counter__changed
counterchanges22124226counter__changes
counterevidence2391586counterevidence_
counterimage1754986counteri__ma_ge_
counterimages1854616counteri__ma_ges
counterirritant1771736counterirritan__t
countermanded1974686counter___manded
counterpane1549316counter___pan_e_
counterpanes1649306counter___pan_es
counterresponse1961766counterresponse_
countersigned1784356counter__sign_ed
counterstain14156786counter__sta__in
counterstaining1863246counter__staining
counterstains15156626counter__sta_ins
counterstating1755196counter__stating
counterstep1547116counter__st___ep
counterstream1773736counter__st__ream
counterstricken2372746counter__stricken
counterstrike1965296counter__strike_
counterstrikes2094746counter__strikes
counterstroke1954786counter__stroke_
counterstrokes2064636counter__strokes
counterstruck2163196counter__struc_k
counterstyle1755056counter__st_yle_
counterstyles1854786counter__st_yles
counterviolence2271566counterviolence_
nonresistance1562656no_nresi_stance_
nonresistances1662196no_nresi_stances
outdistance1452016_ou_t_di_stance_
outdistanced1651266_ou_t_di_stanced
outdistances1551766_ou_t_di_stances
coexistence2253267co___exi_stence_
coexistences2352877co___exi_stences
concomitance1763087co_ncomi__tance_
concomitances1862787co_ncomi__tances
consistence1555677co_n__si_stence_
consistences1655437co_n__si_stences
contestable1546897co_nte___stable_
contestant1269937co_nte___stan__t
contestants1356807co_nte___stan_ts
continence1489137co_nt__in__ence_
continences1588587co_nt__in__ences
contingence16105457co_nt__in_gence_
contingences1794997co_nt__in_gences
contrastable1654437co_nt_r_astable_
conversancies2053597co_nver__s_ancies
conversancy2163807co_nver__s_anc_y
cornerstone1352807corn_er__ston_e_
cornerstones1452887corn_er__ston_es
countenancing1853137counte__n__ancing
counteract1449607counter____a_c_t
counteracted1747367counter____acted
counteracting1856287counter_actin__g
counteractive2055957counter_act_ive_
counteracts1547517counter____a_cts
counterassault1682057counter_assa_ult
counterassaults1791447counter_assaults
countercharge2194297counter__charge_
countercharged23113617counter__charged
countercharges22104117counter__charges
counterclaimed2163527counter__claimed
counterculture1862337countercult_ure_
countercultures1962237countercult_ures
counterdemand1963217counter_deman__d
counterdemands2062397counter_deman_ds
counterfeited1974777counterfeit___ed
counterfeiter1874747counterfeit___er
counterfeiting2054027counterfeitin__g
counterforce1985797counter___force_
counterforces2085557counter___forces
countering13314477counteri____n__g
counterion1249537counteri___on___
counterions1349847counteri___on__s
counterman1448557counter___man___
countermand1647127counter___man__d
countermands1746237counter___man_ds
countermarch2154467counter___marc_h
countermarched2483187counter___marched
countermarches2373747counter___marches
countermine1549747counter___min_e_
countermines1649157counter___min_es
counterplan1586777counter__plan___
counterplans1687147counter__plan__s
counterplayer2055047counter__pla_yer
counterplea1547037counter_____plea
counterplotted1963417counterplot__ted
counterpointed1953597counter__pointed
counterpointing2063037counterpoin_tin__g
counterpose1547507counterpos____e_
counterposed1756327counterpos____ed
counterposes1647627counterpos____es
counterposing1885447counterpos_in__g
counterpunch2154197counter___punc_h
counterpunched2492717counter___punched
counterpuncher2382637counter___puncher
counterpunches2383247counter___punches
countershading2163837counter__shading
countersign1447247counter__sign___
countersigning1863227counter__signing
countersigns1546427counter__sign__s
countersink1748067counter__s_in__k
countersinking2163487countersin_kin__g
countersinks1846167counter__s_in_ks
countersniper17104557counter__s_niper
counterspies1648317counter__s__pies
countersteps1655887counter__st__eps
counterstrategy2182137counter__strategy
counterstreams18102807counter__streams
countersue1247747counter__s___ue_
countersued1447087counter__s___ued
countersues1348537counter__s___ues
countersuing1547087counter__suin__g
countersunk1755267counter__s_un__k
countertactic1663917counter___tactic
countertactics1763367countertact_ic_s
countertendency2371927countertendenc_y
countertenor1454757counter___ten_or
countertenors1554067counter___tenors
counterthreat1854057counter___t_hreat
countertrade1556297counter___trade_
countertrades1655897counter___trades
countervailed19154897counter___vailed
inheritance1654117__inheri__tance_
inheritances1753927__inheri__tances
nonexistence21173527no_n_exi_stence_
nonexistences22112957no_n_exi_stences
overissuance1761737_o__verissuance_
overissuances1861697_o__verissuances
underfinanced2061327__underfin__anced

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.360496363.9
2DLD Change Limit950241538.90610669.7
3Display Results1531530.1101390.9
 (SQL Overall)1786911539.37619058.3
 
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.