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

94 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
counterraids155661(None) 
counterraid1446751counterraid_
counterbids1646042counte_rbids
countermands1746232countermands
countervails1755992countervails
counteracts1547513counte_racts
counterbid1546093counte_rbid_
counterclaims1954443counterclaims
countercries1648993countercries
counterfeits1756213counterfeits
counterfoils1755403counterfoils
countermand1647123countermand_
counterpanes1649303counterpanes
counterparts1646713counterparts
counterrallies1683953counterrallies
counterrally1755523counterrally
counterspies1648313counterspies
counterstains15156623counterstains
countersuits14126593countersuits
countertrade1556293countertra_de
countertrades1655893countertrades
countertrends1674353countertrends
countervail1655653countervai_l
cointerred1346564cointerr_ed_
cointerring1447154cointerr_ing
conelrads1244264co_n_elra_ds
conferrals1545414co_nferra_ls
contrails11410544co_nt__rails
contraries12711934co_nt_raries
cornbraids1572994corn__braids
counteract1449604counte_ra_ct
counterargue1555304counterargue
counterargues1685044counterargues
counterblasts1754004counterblasts
counterblows1954214counterblows
counterclaim1854754counterclai_m
countercoups1854604countercoups
counterdemands2062394counterdemands
countered12313004counte_r_ed_
counterfeit1657734counterfei_t
counterfire1647004counte_rfire
counterfires1747064counterfires
counterflows2054354counterflows
counterfoil1655204counterfoi_l
counterimages1854614counterimages
countering13314474counte_r_ing
counterion1249534counte_r_ion
counterions1349844counte_rions
counterman1448554counterma__n
countermanded1974684countermanded
countermarch2154464countermarch
countermemos1854434countermemos
countermine1549744counte_rmine
countermines1649154countermines
countermoves1956014countermoves
countermyths2253554countermyths
counterorders1654474counterorders
counterpane1549314counterpa_ne
counterpart1547804counterpa_rt
counterplans1687144counterplans
counterplays1995604counterplays
counterpleas1655804counterpleas
counterplots16106234counterplots
counterploys1995354counterploys
counterpoint1658174counterpoint
counterpoints1755624counterpoints
counterpoise1657374counterpoise
counterpoises1756414counterpoises
counterposes1647624counterposes
counterrallied1763254counterrallied
counters103320194counte_r___s
countershots1755934countershots
countersign1447244counte_rsign
countersigns1546424countersigns
countersink1748064counte_rsink
countersinks1846164countersinks
counterstain14156784counterstai_n
counterstates1586644counterstates
countersteps1655884countersteps
countersued1447084countersued_
countersues1348534counte_rsues
countersuing1547084countersuing
countersuit13137504countersui_t
countertactics1763364countertactics
countertops1546354counte_rtops
countertrend1575944countertrend_
countervailed19154894countervailed
counterview19116684counte_rview
counterviews20134874counterviews
counterworlds1953464counterworlds
countries11313614count__r_ies
countryside1752364count_ryside
countrysides1852054count_rysides
countrywide2051804count_rywide

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 Filter1786911247900.406440125.6
2DLD Change Limit124790946.62318841.9
3Display Results94940.0631492.1
 (SQL Overall)178691947.09225196.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.