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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

58 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
countermarching2562601countermarching_
counteracting1856284counter_a_cting_
counterarguing18113404counter_arguing_
countermanding2053744counterma_nding_
countermarch2154464countermarch____
countermarched2483184countermarch__ed
countermarches2373744countermarch__es
counterpunching2562364counterpunching_
countenancing1853135counte_nanc_ing_
counterchange2194865counte___rchange
countercharging24183065counterchar_ging_
counterchecking2662555counterchecking_
countermoving2154165counterm__oving_
counterrallying2162275counterrallying_
counterstriking2262945counterstriking_
countervailing2063735counterva_iling_
interarching1845015__inter_arching_
outmarching1943605_ou_t__marching_
cointerring1447156cointer__r__ing_
contracting16610476co_nt_r_a_cting_
counteraction1755386counter_a_cti_on
counteractions1855026counter_a_ctions
counteractive2055956counter_a_cti_ve
countercampaign2471676countercampai_gn
counterchanged23103776counte___rchanged
counterchanges22124226counte___rchanges
counterchanging24162976counterchanging_
countercharge2194296counte___rcharge
counterclaiming2262926counterclaiming_
counterfeiting2054026counter_feiting_
countering13314476counte___r__ing_
counterman1448556counterma____n__
countermand1647126counterma____n_d
countermands1746236counterma____nds
countermine1549746counterm____in_e
countermines1649156counterm____ines
counterordering19162416counterordering_
counterplotting2062806counterplotting_
counterpointing2063036counterpointing_
counterpoising19164196counter_poising_
counterposing1885446counter__posing_
countershading2163836counter_shading_
countershadings2272706counter_shadings
countersigning1863226counter_signing_
countersinking2163486counter_sinking_
counterstaining1863246counterstaining_
counterstating1755196counter_stating_
countersuing1547086counte___rsuing_
countertactic1663916counterta_cti__c
countertactics1763366counterta_cti_cs
intermarrying1962286__intermarrying_
nonteaching1753586no_nte__a_ching_
outmatching1943336_ou_t__matching_
outpreaching2042346_ou_tprea_ching_
outreaching1744916_ou_t_rea_ching_
overarching2056896_o__ver_arching_
overmatching2353676_o__vermatching_
unteaching1645496__unte__a_ching_

Search took 7 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 Filter178691658740.313570897.8
2DLD Change Limit65874585.73311490.3
3Display Results58580.0461260.9
 (SQL Overall)178691586.09229332.1
 
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.