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

102 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
counterfeiting205402(None) 
counteracting1856283counter_acting
counterfeit1657733counterfeit___
counterfeited1974773counterfeit_ed
counterfeiter1874743counterfeit_er
counterfeiters19103743counterfeiters
counterfeits1756213counterfeit__s
counterpointing2063033counterpointing
counterpoising19164193counterpoising
counterstating1755193counterstating
countervailing2063733countervailing
counterarguing18113404counterarguing
counterchecking2662554counterchecking
counterclaiming2262924counterclaiming
countering13314474counter____ing
countermanding2053744countermanding
countermoving2154164counter_moving
counterpetition1961944counterpetition
counterplotting2062804counterplotting
counterposing1885444counter_posing
countershading2163834countershading
countersigning1863224countersigning
countersinking2163484countersinking
counterstaining1863244counterstaining
counterstriking2262944counterstriking
countersuing1547084counter__suing
cauterizing2345945cau_ter__izing
chuntering1647805chunter____ing
coerecting15218785co___er_ecting
coinfecting1944575coin___fecting
cointerring1447145cointer___ring
conceiting15311775co_n___ceiting
concerting15313895co_ncer___ting
concertizing2655635co_ncer_tizing
concreting1539875co_n_cr_e_ting
confecting18310555co_n___fecting
conferencing2053855co_nfer_encing
consternating1654975conster_nating
contemplating2054125co_ntemplating
contenting13313325co_nt___enting
contesting13312215co_nt___esting
contorting13410105co_ntor___ting
contracting16610475co_nt_r_acting
contradicting1954075co_nt_radicting
contrasting1459355co_nt_r_asting
contributing1754305co_nt_ributing
contriving1648195co_nt_r__iving
controverting1953365co_ntroverting
converting16313135co_nver___ting
countenancing1853135counte_nancing
counteraction1755385counter_action
counteractions1855025counteractions
counteractive2055955counter_active
counterchanging24162975counterchanging
countercharging24183065countercharging
counterdemand1963215counterde_mand
counterfactual2161825counterfactual
counterfire1647005counterf___ire
counterfires1747065counterf_i_res
counterfoil1655205counterf__oi_l
counterfoils1755395counterf__oils
counterion1249535counter__i_on_
counterions1349825counter__i_ons
counterirritant1771735counterirritant
countermarching2562605countermarching
countermen1449295counterme___n_
countermine1549745counter___mine
counterordering19162415counterordering
counterpoint1658175counter__point
counterpunching2562365counterpunching
counterquestion2671215counterquestion
counterrallying2162275counterrallying
counterreaction19102375counterreaction
countershadings2272705countershadings
countersign1447245counter_si_gn_
countersigns1546425counter_si_gns
countersink1748065counter___sink
counterstain14156785counter_stain_
counterstains15156625counter_stains
countersuit13137505countersuit___
countersuits14126595countersuit__s
countertactic1663915countertacti_c
countertactics1763365countertactics
counterweight2263545counterwei_ght
counterweights2372535counterweights
forfeiting1744135fo____rfeiting
intercepting1748875__intercepting
interesting12411125__inter_esting
interfering1558925__interfe_ring
interfiling1546955__interf_iling
interjecting2248395__interjecting
intersecting1549715__intersecting
nonintersecting1871545nonintersecting
outwriting1447185_ou_twr__iting
surfeiting1445025_su___rfeiting
undereating1369555__under_eating
underfeeding1853185__underfeeding
underheating1785135__underheating
underletting1454185__underletting
underwriting1754125__underwriting
uninteresting1482205uninter_esting
winterfeeding2162225_winterfeeding

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.356501941.0
2DLD Change Limit950241027.40612830.7
3Display Results1021020.0631619.0
 (SQL Overall)1786911027.82522835.9
 
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.