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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

176 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
counterreaction1910237(None) 
counteraction1755382counte_r_action
counteractions1855023counte_r_actions
counterpetition1961943counterpetition
contraction15411244co_nt__r_action
counteracting1856284counte_r_acting
counteractive2055954counte_r_active
counterquestion2671214counterquestion
countertactic1663914counte_rtacti_c
countertactics1763364counte_rtactics
overreaction1754924_o__verreaction
cauterization24187755cau_teriza_tion
confederation1995255co_nfedera_tion
consecration1649785co_nsecr_a_tion
conservation1749405co_nse_rva_tion
consternation15106365conste_rna_tion
contemplation1985265co_ntempla_tion
contestation1448665co_nte_sta_tion
contractions16410405co_nt__r_actions
contradiction1854565co_nt_radiction
contraption1548105co_nt__r_aption
conversation1747805co_nve_rsa_tion
correction1448815co____rre_ction
counteract1449605counte_r_act___
counteracted1747365counte_r_act_ed
counteracts1547515counte_r_act__s
counterfactual2161825counte_rfactual
counterfeiting2054025counterfe_iting
counterion1249535counte_r____ion
counterraid1446755counterr_a__i_d
counterraids1556605counterr_a__ids
counterrallied1763255counterr_allied
counterrallies1683955counterr_allies
counterstain14156785countersta__i_n
counterstating1755195countersta_ting
interaction13411815__inte_r_action
interjection2198925__interje_ction
interrelation1358735__interrelation
intersection14610185__interse_ction
overreactions1854725_o__verreactions
underreacting1752835__underreacting
adulteration1353666adulte_r_a_tion
cauterizations25197156cau_teriza_tions
coacervation1964276co_ace_rva_tion
codetermination2062126codetermination
codirection1644746co___dire_ction
cogeneration1546446cogene_r_a_tion
computerization3082786computeriza_tion
concentration1758016co_ncentra_tion
concretion1449296co_n__cre__tion
condemnation1746046co_nde_mna_tion
condensation1546786co_nde_nsa_tion
confection17411186co_n___fe_ction
confederations20104606co_nfedera_tions
confirmation1946186co_n_firma_tion
conformation1947326co_n_forma_tion
congelation14410346co_nge__la_tion
congregation16226766co_n__gregation
conjuration2049516co_n_jur_a_tion
connection14410536co_n___ne_ction
consecrations1749216co_nsecr_a_tions
conservations1849096co_nse_rva_tions
consideration1655526co_nsidera_tion
conspiration1648386co_nspir_a_tion
constellation1554806conste_lla_tion
consternations16116046conste_rna_tions
constriction1648266co_n_str_iction
construction1648086co_n_str_uction
contamination1766956co_ntamina_tion
contemplations2074736co_ntempla_tions
contention12412226co_nt___e_ntion
contestations1547736co_nte_sta_tions
continuation1448196co_nt_inua_tion
contortion1248666co_nt_or___tion
contraception1953756co_nt_raception
contractile1547356co_nt__r_actile
contracting16610476co_nt__r_acting
contractional1756066co_nt__r_actional
contractive1849526co_nt__r_active
contractor1449076co_nt__r_act_or
contradictions1954146co_nt_radictions
contraptions1647646co_nt__r_aptions
contravention18103876co_nt_ravention
contribution1655096co_nt__ribution
contrition12411416co_nt__r__ition
conurbation1547466co_n__urba_tion
convection17411126co_n___ve_ction
conversations1847456co_nve_rsa_tions
cooperation15410026co_ope_r_a_tion
corrections1548866co____rre_ctions
correlation1358556co____rrelation
counterattack2172736counte_r_attack
counterblast1655406counterblast___
counterblasts1754006counterblast__s
countercampaign2471676countercampaign
counterchanging24162976counterchanging
countercharging24183066countercharging
counterchecking2662556counterchecking
counterclaim1854756countercla__i_m
counterclaiming2262926counterclaiming
counterclaims1954446countercla__ims
countercries1648996counte_r__cries
counterfeit1657736counterfe___i_t
counterfeited1974776counterfe_it_ed
counterfeiter1874746counterfe_it_er
counterfeiters19103746counterfe_iters
counterfeits1756216counterfe___its
counterions1349826counte_r____ions
counterman1448556counte_rma____n
countermanding2053746counte_rmanding
countermarching2562606countermarching
countermeasure18122636countermea_sure
countermeasures19122296countermeasures
countermelodies2092166countermelodies
countermemo1754726counterme___mo_
countermemos1854436counterme___mos
countermen1449296counterme_____n
counterpart1547806counte_rpart___
counterparts1646716counte_rpart__s
counterplan1586776counterpla____n
counterplotting2062806counterplotting
counterpointing2063036counterpointing
counterpunching2562366counterpunching
counterrally1755526counterr_a__lly
counterrallying2162276counterrallying
counterreform2062586counterre__form
counterreformer2271626counterreformer
counterreforms2162176counterre_forms
counterresponse1961766counterresponse
countershading2163836countersha_ding
countersign1447246counte_r___sign
counterstaining1863246counterstaining
counterstains15156626countersta__ins
counterstate1457036countersta_t__e
counterstated1665636countersta_t_ed
counterstates1586646countersta_t_es
countertenor1454756counterte___nor
counterterror1562556counterte__rror
counterthreat1854056counterthrea_t___
counterthreats1962876counterthrea_t__s
countertop1445846counte_r___t_op
countervail1655656counte_rva__i_l
countervailing2063736counte_rvailing
countervails1755996counte_rva__ils
deuteration1249106deu_te_r_a_tion
exenteration1955296exente_r_a_tion
insurrection14104386__insurre_ction
integration121310496__integr_a_tion
intellection1466176__intelle_ction
inteneration1248626__intenera_tion
interactions14410466__inte_r_actions
interception1649396__interce_ption
interdiction1568146__inte_rdiction
interjections2277996__interje_ctions
interpretation16115866__interpretation
interrelations1457616__interrelations
interrogation1457866__interrogation
interruption1466406__interr_uption
intersections1598966__interse_ctions
interstation12410416__intersta_tion
intervention1568386__interve_ntion
noncorrelation16113086no_ncorrelation
nonelection1347206no_n_e_le_ction
nonintervention1871496noninterve_ntion
nonsegregation16132806no_nsegregation
overaction1547996_o__ve_r_action
overreacting1856666_o__verreacting
photoreaction20134176_phot_oreaction
postelection1654556po_ste_le_ction
putrefaction1952466_pu_t_refaction
reintegration14175376reintegr_a_tion
subtraction1545626_subt__r_action
underreact1344686__underreact___
underreacted1653606__underreact_ed
underreacts1453026__underreact__s
winterization25137816_winteriza_tion

Search took 9 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 Limit950241767.73312288.1
3Display Results1761760.1401257.1
 (SQL Overall)1786911768.23321704.2
 
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.