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

96 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
countersnipers189327(None) 
countersniper17104551countersniper_
counterfeiters19103743counterfeiters
counterspies1648313counterspi_e_s
countenancers1752984countenan_cers
countercries1648994countercri_e_s
counterfeiter1874744counterfeiter_
counterfires1747064counter_fire_s
countermines1649154counter_mine_s
counteroffers2153264counter_offers
counterorders1654474counter_orders
counterplayers2153804counterplayers
counterpoises1756414counterpoise_s
counterpowers2064824counter_powers
counterpunchers2482014counterpunchers
countersigns1546424counters_i_gns
countersinks1846164counters_i_nks
counterspell1653914counters__pell
counterspells1753464counters__pells
counterstates1586644counterstate_s
countersteps1655884counters__teps
counterstrikes2094744counterstrike_s
counterstyles1854784counterstyle_s
countersues1348534counters__ue_s
countersuits14126594countersui__ts
counterviews20134874counter_vi_ews
guttersnipes1561064_guttersnipe_s
contemners1447075co_nte_mn__ers
contenders1348625co_nte__n_ders
contesters12410195co_nte_s__ters
contrivers1547255co_nt_r__ivers
conversers1547355co_nvers___ers
countenancer1654225countenan_cer_
countenances1655735countenan_ce_s
counterargues1685045counterargue_s
counterbids1646045counter_bi__ds
countercoups1854605countercoup__s
counterfeited1974775counterfeite_d
counterfeits1756215counterfei__ts
counterfire1647005counter_fi__re
counterfoils1755405counterfoi__ls
counterforces2085555counterforce_s
counterimages1854615counterimage_s
counterions1349845counter__i_ons
countermine1549745counter_mine__
countermoves1956015counter_move_s
counteroffer2054115counter_offer_
counterorder1555625counter_order_
counterpanes1649305counter_pane_s
counterpart1547805counter___part
counterparts1646715counter___parts
counterpickets2463315counterpickets
counterplayer2055045counterplayer_
counterpleas1655805counter__pleas
counterpoints1755625counterpoi_nts
counterpoise1657375counterpoise__
counterpoised1855305counterpoise_d
counterposes1647625counter_pose_s
counterpower1965865counter_power_
counterpuncher2382635counterpuncher_
counterpunches2383245counterpunche_s
counterraids1556615counterrai__ds
countershots1755935counters__hots
countersign1447245counters_i__gn
countersigned1784355counters_igned
countersink1748065counters_i__nk
countersinking2163485countersinking
counterspy1744665counters__p__y
counterstained1754845counterstaine_d
counterstains15156625counters_tains
counterstate1457035counterstate__
counterstated1665645counterstate_d
counterstep1547115counters__te_p
counterstream1773735counters_tream
counterstreams18102805counterstreams
counterstrike1965295counterstrike__
counterstrokes2064635counterstrokes
counterstyle1755055counterstyle__
countersue1247745counters__ue__
countersued1447085counters__ue_d
countersuing1547085countersui__ng
countersuit13137505countersui___t
countertenors1554065counter_tenors
counterterrors1662485counterterrors
countertops1546355counter_top__s
countertrades1655895countertrade_s
countervailed19154895countervaile_d
countervails1755995countervai__ls
counterview19116685counter_vi_e_w
counterweights2372535counterweights
countesses1248845counte_s__se_s
countries11313615count_r__i_e_s
countrysides1852055count_ryside_s
courtesies1246455courte_s_i_e_s
couturiers1243855cou_tur__i_ers
guttersnipe1461115_guttersnipe__

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 Filter178691950240.390458182.1
2DLD Change Limit95024967.11013364.8
3Display Results96960.0631523.8
 (SQL Overall)178691967.56323627.0
 
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.