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

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

54 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
countermanded197468(None) 
countermand1647122counterman__d
countermands1746232countermand_s
countenanced1754203counte_nanced
counteracted1747363counter_acted
counterchanged23103773counterchanged
counterman1448553counterman___
countermanding2053743countermanding
countermarched2483183countermarched
countermine1549743countermin_e_
countermines1649153countermin_es
countermoved2054993counterm_oved
counterpane1549313counterpan_e_
counterpanes1649303counterpan_es
countervailed19154893countervailed
contemned1446794co_nte_m_n_ed
contended1339274co_nte___nded
countenance1555874counte_nance_
countenancer1654224counte_nancer
countenances1655734counte_nances
counterargued1754224counterargued
counterbalanced22142574counterbalanced
counterchange2194864counterchange_
counterchanges22124224counterchanges
countercharged23113614countercharged
counterclaimed2163524counterclaimed
counterdemand1963214counterdeman__d
counterdemands2062394counterdemand_s
countered12313004counter____ed
counterfeited1974774counterfeited
counterimage1754984counterima_ge_
counterimages1854614counterima_ges
countermarch2154464counterma_rch
countermarches2373744countermarches
countermen1449294counterm___en
countermove1855854counterm_ove_
countermoves1956014counterm_oves
counterorder1555624counter_order
counterpointed1953594counterpointed
counterpoised1855304counterpoised
counterposed1756324counter_posed
counterpunched2492714counterpunched
counterraid1446754counterra__id
counterraids1556614counterraid_s
counterrallied1763254counterrallied
countersigned1784354countersigned
counterstained1754844counterstained
counterstated1665644counterstated
countersued1447084counter__sued
countertrade1556294countertrade_
countertrades1655894countertrades
mountebanked2181594mounte_banked
underhanded1744664__underhanded
undermanned1544184__undermanned

Search took 6 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 Limit95024544.97019119.5
3Display Results54540.0301800.0
 (SQL Overall)178691545.36033337.9
 
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.