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

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
counterrallies168395(None) 
counterrallied1763251counterrallied
counterraids1556603counterra__ids
counterrally1755523counterrall__y
counterrallying2162273counterrallying
counterargues1685044counte_rargues
counterbalances21122824counterbalances
counterclaims1954444counte_rclaims
countercries1648994counte_r_cries
countermarches2373744countermarches
countermelodies2092164countermelodies
counterpanes1649304counterpa__nes
counterraid1446754counterra__i_d
counterspies1648314counte_r_spies
counterstyles1854784counterstyl_es
countertactics1763364countertactics
countertrades1655894countertra__des
countervailed19154894countervail_ed
countervailing2063734countervailing
countervails1755994counterva__ils
chanterelles1751905chante_rell_es
conferrable1845825co_nferrabl_e_
conferrals1545405co_nferra_l__s
conservancies2054115co_nservancies
contraries12711935co_nt__ra_ries
conversancies2053595co_nversancies
countenances1655735counte_na_nces
counteracted1747365counte_ra_cted
counteracting1856285counte_racting
counteraction1755385counte_raction
counteractions1855025counte_ractions
counteractive2055955counte_ractive
counteracts1547515counte_ra__cts
counteragents1655175counte_ragents
counterargue1555305counte_rargue_
counterargued1754225counte_rargued
counterarguing18113405counterarguing
counterbalance20123245counterbalance
counterbalanced22142575counterbalanced
counterbids1646035counte_r__bids
counterblasts1754005counte_rblasts
counterblows1954215counte_r_blows
counterchanges22124225counterchanges
countercharges22104115countercharges
counterclaim1854755counte_rclai_m
counterclaimed2163525counterclaimed
countercultures1962235countercultures
counterexamples28251535counterexamples
counterfeits1756215counte_r_feits
counterfires1747065counte_r_fires
counterflows2054355counte_r_flows
counterfoils1755395counte_r_foils
counterforces2085555counte_rforces
counterimages1854615counte_rimages
countermanded1974685counterma_nded
countermanding2053745countermanding
countermands1746235counterma__nds
countermarched2483185countermarched
countermeasures19122295countermeasures
countermines1649155counte_r_mines
countermoves1956015counte_r_moves
counterpane1549315counterpa__ne_
counterparts1646715counterpa__rts
counterplans1687145counte_r_plans
counterplayer2055045counte_rplayer
counterplayers2153805counterplayers
counterplays1995605counte_r_plays
counterplea1547035counte_r_pl_ea
counterpleas1655805counte_r_pleas
counterplots16106235counte_r_plots
counterploys1995355counte_r_ploys
counterpoise1657355counte_r_poise
counterpoises1756415counte_rpoises
counterposes1647625counte_r_poses
counterpunches2383245counterpunches
counterreaction19102375counterreaction
counterreforms2162175counterreforms
counterspells1753465counterspel_ls
counterstains15156625counte_rstains
counterstates1586645counte_rstates
counterstrikes2094745counterstrikes
counterstrokes2064625counterstrokes
counterstyle1755055counterstyl_e_
countersues1348535counte_r__sues
countersuits14126595counte_r_suits
countertactic1663915countertacti_c
countertrade1556295countertra__de_
countervail1655655counterva__i_l
counterview19116685counte_r__view
counterviews20134875counte_r__views
counterworlds1953465counterworl_ds
countries11313615count__r___ies
interallied1246065__inte_rallied
underbellies1552285__underbellies

Search took 10 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.716249568.4
2DLD Change Limit95024948.19011602.4
3Display Results94940.0761236.8
 (SQL Overall)178691948.98219894.3
 
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.