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

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

101 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
countermanding205374(None) 
countenancing1853133counte_nancing
counteracting1856283counter_acting
counterchanging24162973counterchanging
countermand1647123countermand___
countermanded1974683countermand_ed
countermands1746233countermand__s
countermarching2562603countermarching
countermoving2154163counterm_oving
countershading2163833countershading
countersinking2163483countersinking
countervailing2063733countervailing
contemning1577064co_nte_m_n_ing
contending1449124co_nte___nding
counterarguing18113404counterarguing
countercharging24183064countercharging
counterclaiming2262924counterclaiming
counterfeiting2054024counterfeiting
countering13314474counter____ing
counterman1448554counterma___n_
countermine1549744counterm___ine
counterpointing2063034counterpointing
counterpoising19164194counterpoising
counterposing1885444counter_posing
counterpunching2562364counterpunching
counterrallying2162274counterrallying
countershadings2272704countershadings
countersigning1863224countersigning
counterstaining1863244counterstaining
counterstating1755194counterstating
countersuing1547084counter__suing
mountebanking2261544mounte_banking
nondemanding1752464no_nde_manding
undemanding1653444__unde_manding
chuntering1647805chunter____ing
coattending1543545coatte___nding
coextending2252915coexte___nding
cointerring1447155cointer___ring
commanding1845925co____mmanding
concerning1548905co_ncer__n_ing
condemning1665745co_nde_m_n_ing
condescending2052285co_ndescending
conferencing2053855co_nfer_encing
consternating1654975consterna_ting
contenting13313325co_nte___nting
contracting16610475co_nt_r_acting
contrasting1459355co_nt_r_asting
conveyancing2352015co_nve_yancing
cornbraiding1861605corn_br_aiding
counteraction1755385counter_action
counteractions1855025counter_actions
counteractive2055955counter_active
counteragent1557695counter_a_gent
countercampaign2471675countercampaign
counterchecking2662555counterchecking
counterdemand1963215counterdemand___
counterdemands2062395counterdemand__s
countermarch2154465counterma__rch
countermarched2483185countermarched
countermarches2373745countermarches
countermelodies2092165countermelodies
countermen1449295counterm___en_
countermines1649155countermin__es
counterordering19162415counterordering
counterpane1549315counterpa___ne
counterpanes1649305counterpan__es
counterplotting2062805counterplotting
counterpoint1658175counter__point
counterraid1446755counterra__i_d
counterraids1556615counterra__ids
counterrallied1763255counterrallied
counterrallies1683955counterrallies
countersign1447245counter___sign
countersink1748065counter___sink
counterstain14156785counter_stain_
counterstains15156625counter_stains
counterstriking2262945counterstriking
countertactic1663915countertacti_c
countertactics1763365countertactics
countertendency2371925countertendency
countervail1655655counterva__i_l
countervails1755995counterva__ils
downtrending1851385downt_r_ending
interlarding1445565__interlarding
interlending1456415__interlending
intermatting1547175__intermatting
masterminding1961165_masterminding
nonterminating1773125no_nterminating
outmanning1345545_ou_t__manning
outranging1238005_ou_t_r_anging
outranking1537675_ou_t_r_anking
outreading1239285_ou_t_rea_ding
outstanding1344555_ou_t_standing
outtrading1247155_ou_ttr_a_ding
overhanding1947025_o__verhanding
overmanning1745945_o__vermanning
underfunding1873505__underfunding
undermining1546365__undermin_ing
understanding1673775__understanding
unthreading1644155__unthrea_ding
untreading1247565__unt_rea_ding

Search took 9 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.423422437.4
2DLD Change Limit950241017.65612411.7
3Display Results1011010.0761328.9
 (SQL Overall)1786911018.15521911.8
 
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.