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

121 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
counterrallying216227(None) 
counterrallied1763253counterrall_ied
counterrallies1683953counterrall_ies
counterrally1755523counterrally___
countervailing2063733countervail_ing
counteracting1856284counte_ra_cting
counterarguing18113404counte_rarguing
counterclaiming2262924counterclaiming
countermanding2053744counterma_nding
countermarching2562604countermarching
cointerring1447145cointerr____ing
controlling1445425co_nt__roll_ing
corralling1345435co____rrall_ing
counselling1444405counse___ll_ing
countenancing1853135counte_na_ncing
countercampaign2471675countercampaign
counterchanging24162975counterchanging
countercharging24183065countercharging
counterchecking2662555counterchecking
counterfeiting2054025counte_rfeiting
countering13314475counte_r____ing
countermoving2154165counte_r_moving
counterordering19162415counterordering
counterplotting2062805counterplotting
counterpointing2063035counterpointing
counterpoising19164195counte_rpoising
counterposing1885445counte_r_posing
counterpunching2562365counterpunching
counterraid1446755counterra___i_d
counterraids1556605counterra___ids
countershading2163835counte_rshading
countersigning1863225counte_rsigning
countersinking2163485counte_rsinking
counterstaining1863245counterstaining
counterstating1755195counte_rstating
counterstriking2262945counterstriking
countersuing1547085counte_r__suing
butterflying2151146_butte_r_flying
caterwauling1851706c__aterwaul_ing
centralising1555936c_ent__ralising
centralizing2458056c_ent__ralizing
chuntering1647806chunte_r____ing
coinferring1744206coinferr____ing
collateralizing2762066collate_ralizing
concealing1549306co_nce__a_l_ing
conferring1648746co_nferr____ing
congealing1447636co_nge__a_l_ing
consecrating1747946co_nsecra__ting
conservatizing2983096co_nservatizing
consternating1654976consterna__ting
contemplating2054126co_nte_mplating
contextualizing3462496co_ntextualizing
contracting16610476co_nt__ra_cting
contrasting1459356co_nt__ra_sting
contravening1853566co_nt__ravening
counseling1345466counse____l_ing
counsellings1552116counse___ll_ings
counteraction1755386counte_ra_ction
counteractions1855026counte_ractions
counteractive2055956counte_ra_ctive
counteragent1557696counte_ra__gent
counterargument2072026counterargument
counterbalance20123246counterba_lance
counterbalanced22142576counterbalanced
counterbalances21122826counterbalances
counterclaim1854756counte_r_clai_m
counterclaims1954446counte_r_claims
counterman1448556counterma____n_
countermand1647126counterma____nd
countermelodies2092166countermelodies
countermine1549746counte_r___mine
counterpane1549316counterpa____ne
counterplan1586776counte_r_pl_an_
counterplans1687146counte_r_pl_ans
counterplay18105606counte_rplay___
counterplayer2055046counte_rplay_er
counterplayers2153806counte_rplayers
counterplays1995606counte_rplay__s
counterploy18105206counte_rploy___
counterploys1995356counte_rploy__s
counterpoint1658176counte_r__point
counterreaction19102376counterreaction
countershadings2272706counte_rshadings
countersign1447246counte_r___sign
countersink1748066counte_r___sink
counterstain14156786counte_r_stain_
counterstains15156626counte_r_stains
countertactic1663916counterta_cti_c
countertactics1763366counterta_ctics
countervail1655656counterva___i_l
countervailed19154896countervail__ed
countervails1755996counterva___ils
courtesying1743126courte____sying
curveballing2051256c_urve_ball_ing
enthralling1543846__ent_hrall_ing
intercalating1656506__intercalating
interlaying1547576__inte_r_laying
intermarrying1962286__intermarrying
internalising1455626__internalising
internalizing2356216__internalizing
interplaying1845516__inte_rplaying
interrelating1457296__interrelating
intertilling1355376__intertill_ing
inthralling1544116__int_hrall_ing
lateralling1244636__late_rall_ing
mountebanking2261546mounte_ba_nking
outbrawling1743706_ou_t_brawl_ing
outbullying1752296_ou_t__bullying
outcrawling1743656_ou_t_crawl_ing
outpraying1646526_ou_t_pra__ying
outrivalling1651706_ou_trivall_ing
outrolling1137536_ou_t__roll_ing
outtelling11107136_outte___ll_ing
overcalling1747326_o__vercall_ing
underlaying16125766__unde_r_laying
underlying15136376__unde_r__lying
underpaying18125376__underpa__ying
underplaying19154356__unde_rplaying
underrating1388256__underra__ting
underselling1453976__undersell_ing
undervaluing1753386__underva_luing

Search took 8 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 Limit950241217.28013052.7
3Display Results1211210.0961260.4
 (SQL Overall)1786911217.73623098.6
 
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.