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

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

56 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
counterimage175498(None) 
counterimages1854611counterimages
counterchange2194863counterchange
countercharge2194293countercharge
countering13314473counteri_ng_
counterman1448553counter_ma_n
countermand1647123counter_mand
countermine1549743counter_mine
countermove1855853counter_move
counterpane1549313counter_pane
counterstate1457033counterstate
countertrade1556293countertrade
afterimage1652324__afterimage
chuntering1647804chunteri_ng_
counteract1449604counter__act
counteragent1557694counter__agent
counterargue1555304counterargue
counterblast1655404counterblast
counterchanged23103774counterchanged
counterchanges22124224counterchanges
countercharged23113614countercharged
countercharges22104114countercharges
counterclaim1854754counterclaim
counterdemand1963214counterdemand
counterfire1647004counter_fire
counterforce1985794counterforce
counterion1249534counteri__on
counterions1349844counteri_ons
countermanded1974684counter_manded
countermands1746234counter_mands
countermarch2154464counter_march
countermemo1754724counter_memo
countermen1449294counter_m_en
countermines1649154countermines
countermoved2054994counter_moved
countermoves1956014counter_moves
countermyth2153794counter_myth
counterpanes1649304counter_panes
counterpart1547804counter_part
counterplan1586774counterpla_n
counterplans1687144counterplans
counterplay18105604counterpla_y
counterplayer2055044counterplayer
counterplays1995604counterplays
counterpoise1657374counterpoise
counterpose1547504counter_pose
counterraid1446754counter_raid
countersign1447244counter_sign
counterstain14156784counterstain
counterstated1665644counterstated
counterstates1586644counterstates
counterstyle1755054counterstyle
countersue1247744counter__sue
countertrades1655894countertrades
countervail1655654counter_vail
countryman1753574count_ryma_n

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 Filter1786911247900.406440125.6
2DLD Change Limit124790567.75016101.9
3Display Results56560.0331697.0
 (SQL Overall)178691568.18921820.9
 
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.