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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
counterattacker237179(None) 
counterattacked2471951counterattacked
counterattack2172732counterattack__
counterattacks2272252counterattack_s
counterstricken2372744counterstricken
countenancer1654225countena__nc_er
counteracted1747365counter___acted
counteractive2055955counteract_ive_
counterchecked2562645counter_checked
counterpicket2355165counter__picket
counterplayer2055045counter_pla_yer
counterpuncher2382635counter_puncher
counterstained1754845counter_stained
counterstate1457035counter_sta_te_
counterstated1665635counter_sta_ted
counterstates1586645counter_sta_tes
counterstrike1965295counter_strike_
counterstrikes2094745counter_strikes
counterstroke1954785counter_stroke_
counterstrokes2064625counter_strokes
counterstruck2163195counterstruck__
countertactic1663915counter__tactic
countertrade1556295counter_tra_de_
countertrades1655895counter_tra_des
concertmaster1962046co_ncer_tmaster
contrastable1654436co_nt_rastable_
countenance1555876countena__nc_e_
countenanced1754206countena__nc_ed
countenancers1752986countena__nc_ers
countenances1655736countena__nc_es
counteract1449606counter___ac__t
counteracting1856286counteract__ing
counteraction1755386counteract__ion
counteractions1855026counteract_ions
counteracts1547516counter___ac_ts
counterargue1555306countera__rgue_
counterargued1754226countera__rgued
counterargues1685046countera__rgues
counterassault1682056counterassa_ult
counterassaults1791446counterassaults
counterbalance20123246counterbalance_
counterbalanced22142576counterbalanced
counterbalances21122826counterbalances
counterchange2194866counter_change_
counterchanged23103776counter_changed
counterchanges22124226counter_changes
countercharge2194296counter_charge_
countercharged23113616counter_charged
countercharges22104116counter_charges
countercheck2254116counter_check__
counterchecks2353326counter_check_s
counterclaimed2163526counter_claimed
counterfeiter1874746counter__feiter
counterforce1985796counter_forc_e_
counterforces2085556counter_forc_es
counterimage1754986counter_ima_ge_
counterimages1854616counter_ima_ges
counterinstance19101796counterinstance_
countermanded1974686counter__manded
countermarched2483186counter_marched
countermarches2373746counter_marches
countermeasure18122636counter_measure
counteroffer2054116counter___offer
counterorder1555616counter___order
counterpane1549316counter__pa_ne_
counterpanes1649306counter__pa_nes
counterpickets2463316counter__pickets
counterplayers2153806counter_pla_yers
counterpower1965866counter___power
counterpunched2492716counter_punched
counterpunchers2482016counter_punchers
counterpunches2383246counter_punches
counterreformer2271626counterreformer
countersniper17104556counter__sniper
counterstain14156786counter_sta__in
counterstains15156626counter_sta_ins
counterstating1755196counter_stating
counterstep1547116counter_st___ep
counterstrategy2182136counterstrategy
counterstyle1755056counter_st_yle_
counterstyles1854786counter_st_yles
countertactics1763366counter__tactics
countertenor1454756counter__t_enor
counterterror1562556counter__terror
countervailed19154896counter__vailed
undertaker1545786__under__ta_ker

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 Limit95024867.59312514.7
3Display Results86860.0631365.1
 (SQL Overall)178691868.01622291.8
 
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.