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

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

114 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
counterattacker2371791counterattacker_
counterattacked2471952counterattacke_d
counterattack2172733counterattack___
counterattacks2272253counterattack__s
counterstricken2372745counterstricke_n
countenancer1654226countena__nc_er_
countenancers1752986countena__nc_ers
counteracted1747366counter___acte_d
counteractive2055956counteract_ive__
counterchecked2562646counter_checke_d
counterpicket2355166counter__picke_t
counterpickets2463316counter__pickets
counterplayer2055046counter_pla_yer_
counterplayers2153806counter_pla_yers
counterpuncher2382636counter_puncher_
counterpunchers2482016counter_punchers
counterstained1754846counter_staine_d
counterstate1457036counter_sta_te__
counterstated1665646counter_sta_te_d
counterstates1586646counter_sta_te_s
counterstrategy2182136counterstra_tegy
counterstrike1965296counter_strike__
counterstrikes2094746counter_strike_s
counterstroke1954786counter_stroke__
counterstrokes2064636counter_stroke_s
counterstruck2163196counterstruck___
countertactic1663916counter__tac_tic
countertactics1763366counter__tactics
countertrade1556296counter_tra_de__
countertrades1655896counter_tra_de_s
concertmaster1962047co_ncer_tmaster_
concertmasters2061547co_ncer_tmasters
contralateral1562277co_nt_ra_la_teral
contrastable1654437co_nt_rastable__
countenance1555877countena__nc_e__
countenanced1754207countena__nc_e_d
countenances1655737countena__nc_e_s
counteract1449607counter___ac___t
counteracting1856287counter___acting
counteraction1755387counter___action
counteractions1855027counteract__ions
counteracts1547517counter___ac__ts
counteragent1557697counter___a_gent
counterargue1555307countera__rgue__
counterargued1754227countera__rgue_d
counterargues1685047countera__rgue_s
counterargument2072027countera_rgument
counterassault1682057counterassa__ult
counterassaults1791447counterassa_ults
counterbalance20123247counterbalance__
counterbalanced22142577counterbalance_d
counterbalances21122827counterbalance_s
counterblockade2671017counter_blockade
counterchange2194867counter_change__
counterchanged23103777counter_change_d
counterchanges22124227counter_change_s
countercharge2194297counter_charge__
countercharged23113617counter_charge_d
countercharges22104117counter_charge_s
countercheck2254117counter____check
counterchecking2662557counter_checking
counterchecks2353327counter_check__s
counterclaimed2163527counter_claime_d
countercry1745097counter____c__ry
counterfactual2161827counter__factual
counterfeiter1874747counter__feiter_
counterfeiters19103747counter__feiters
counterforce1985797counter_forc_e__
counterforces2085557counter_forc_e_s
counterimage1754987counter_ima_ge__
counterimages1854617counter_ima_ge_s
counterinstance19101797counterinstance__
countermanded1974687counter__mande_d
countermarched2483187counter_marche_d
countermarches2373747counter_marche_s
countermeasure18122637counter_mea_sure
countermeasures19122297counter_measures
counteroffer2054117counter___offer_
counteroffers2153267counter___offers
counterorder1555627counter___order_
counterorders1654477counter___orders
counterpane1549317counter__pa_ne__
counterpanes1649307counter__pa_ne_s
counterpart1547807counter__pa___rt
counterpicketed2671627counter__picketed
counterplea1547037counter____ple_a
counterpower1965867counter___power_
counterpowers2064827counter___powers
counterpunched2492717counter_punche_d
counterpunches2383247counter_punche_s
counterreaction19102377counter_reaction
counterreformer2271627counterreformer_
countersniper17104557counter__sniper_
countersnipers1893277counter__snipers
counterstain14156787counter_sta___in
counterstaining1863247counter_staining
counterstains15156627counter_sta__ins
counterstating1755197counter_sta_ting
counterstep1547117counter_st___e_p
countersteps1655887counter_st___eps
counterstream1773737counter_st__ream
counterstriking2262947counter_striking
counterstyle1755057counter_st_yle__
counterstyles1854787counter_st_yle_s
countertenor1454757counter__t_enor_
countertenors1554067counter__t_enors
counterterror1562557counter__terror_
counterterrors1662487counter__terrors
counterthreat1854057counter__t_hreat
countertrend1575947counter__t__rend
countervailed19154897counter__vaile_d
mountebankery247837mounte___bankery
undertaker1545787__under__ta_ker_
undertakers1643817__under__ta_kers

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.466383457.1
2DLD Change Limit950241149.31310203.4
3Display Results1141140.0931225.8
 (SQL Overall)1786911149.87218100.8
 
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.