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

99 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
countervailing206373(None) 
counteracting1856283counter_acting
counterclaiming2262923counterclaiming
counterfeiting2054023counterfeiting
countermanding2053743countermanding
counterpoising19164193counterpoising
counterrallying2162273counterrallying
counterstaining1863243counterstaining
countervail1655653countervail___
countervailed19154893countervail_ed
countervails1755993countervail__s
conservatizing2983094co_nservatizing
countenancing1853134counte_nancing
counterarguing18113404counterarguing
counterchanging24162974counterchanging
countercharging24183064countercharging
countering13314474counter____ing
countermarching2562604countermarching
countermoving2154164counter_moving
counterpointing2063034counterpointing
counterposing1885444counter_posing
counterrallied1763254counterrallied
counterrallies1683954counterrallies
countershading2163834countershading
countersigning1863224countersigning
countersinking2163484countersinking
counterstating1755194counterstating
counterstriking2262944counterstriking
countersuing1547084counter__suing
caterwauling1851705c__aterwauling
cauterizing2345945cau_ter__izing
chuntering1647805chunter____ing
cocktailing2052785cockt___ailing
cointerring1447145cointer___ring
concealing1549305co_nce__a_ling
concertizing2655635co_ncer_tizing
congealing1447635co_nge__a_ling
conserving1639755co_nserv___ing
consternating1654975consterna_ting
constraining1554545co_nstr_aining
containing13410935co_nt___aining
contracting16610475co_nt_r_acting
contrasting1459355co_nt_r_asting
contravening1853565co_nt_ravening
contriving1648195co_nt_r__iving
controlling1445425co_nt_r_olling
cornbraiding1861605corn_br_aiding
counseling1345465counse____ling
counselling1444405counse___lling
counteraction1755385counter_action
counteractions1855025counter_actions
counteractive2055955counter_active
counteragent1557695counter_a_gent
counterbalance20123245counterba_lance
countercampaign2471675countercampaign
counterchecking2662555counterchecking
counterfoil1655205counterfoil___
counterfoils1755395counterfoil__s
counterion1249535counter__i_on_
counterions1349825counter__i_ons
counterman1448555counterma___n_
countermand1647125counterma___nd
countermine1549745counter___mine
counterordering19162415counterordering
counterpane1549315counterpa___ne
counterplan1586775counter__plan_
counterplans1687145counter__plans
counterplotting2062805counterplotting
counterpoint1658175counter__point
counterpunching2562365counterpunching
counterraid1446755counterra__i_d
counterraids1556605counterra__ids
counterrally1755525counterra_l_ly
countershadings2272705countershadings
countersign1447245counter_si_gn_
countersigns1546425counter_si_gns
countersink1748065counter___sink
counterstain14156785counter_stain_
counterstains15156625counter_stains
countertactic1663915countertacti_c
countertactics1763365countertactics
counterview19116685counterv___iew
counterviews20134875counterv_i_ews
counterviolence2271565counterviolence
curtailing1344605c_u___rtailing
entertaining1354385__entertaining
fountaining15103645fount___aining
interfiling1546955__inter_filing
mountebanking2261545mounte_banking
outbrawling1743705_ou_tbr_awling
outcaviling1742985_ou_tcav_iling
outcrawling1743655_ou_tcr_awling
outraising1139905_ou_t_r_aising
outrivaling1543755_ou_triva_ling
outrivalling1651705_ou_trivalling
outsailing1137565_ou_t__sailing
outtraveling1652035_ou_ttraveling
unavailing1443375__un__availing
undervaluing1753385__undervaluing

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 Limit95024996.92013731.8
3Display Results99990.0631571.4
 (SQL Overall)178691997.34324334.9
 
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.