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

80 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
countertrade155629(None) 
countertrades1655891countertrades
counterargue1555303counterargue
counterimage1754983counterimage
counterorder1555613counteror_der
counterpane1549313counter_pane
counterraid1446753counter_raid
counterraids1556603counter_raids
counterstate1457033counterstate
counterstrike1965293counterstrike
counterstroke1954783counterstroke
countertrend1575943countertrend
countertrends1674353countertrends
cointerred1346554cointer_red_
concentrate15118354co_ncentrate
counteract1449604counte__ract
counteracted1747364counteracted
counterargued1754224counterargued
counterargues1685044counterargues
counterattack2172734counterattack
counterbid1546084counter_bid_
counterbids1646034counter_bids
counterblast1655404counterblast
counterchange2194864counterchange
countercharge2194294countercharge
counterclaim1854754counterclaim
countercries1648994countercries
countercry1745094countercr__y
countered12313004counte__red_
counterfire1647004counter_fire
counterforce1985794counterforce
counterimages1854614counterimages
counterman1448554counter_ma_n
countermand1647124counter_mand
countermanded1974684countermanded
countermands1746234countermands
countermarch2154464countermarch
countermine1549744counter_mine
countermove1855854counter_move
countermoved2054994countermoved
counterorders1654474counteror_ders
counterpanes1649304counter_panes
counterpart1547804counter_part
counterparts1646714counterparts
counterplan1586774counterpla_n
counterplans1687144counterplans
counterplay18105604counterpla_y
counterplayer2055044counterplayer
counterplays1995604counterplays
counterpoise1657354counterpoise
counterpose1547504counter_pose
counterposed1756324counterposed
counterrally1755524counter_rally
counterstain14156784counterstain
counterstated1665634counterstated
counterstates1586644counterstates
counterstrategy2182134counterstrategy
counterstream1773734counterstream
counterstreams18102804counterstreams
counterstrikes2094744counterstrikes
counterstrokes2064624counterstrokes
counterstruck2163194counterstruck
counterstyle1755054counterstyle
countersue1247744counte__rsue
countersued1447074countersued_
countertenor1454754countertenor
counterterror1562554counterterror
counterthreat1854054counterthreat
counterthreats1962874counterthreats
counterthrust1873604counterthrust
countertop1445844countert__op
countertops1546354countert_ops
countervail1655654counter_vail
counterworld1854224counterworld_
counterworlds1953464counterworlds
countryside1752364count_ryside
countrywide2051804count_rywide
intergrade1247364__intergrade
outtrade938344_ou_t__trade
overtrade1348514_o__vertrade

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 Filter1786911247900.436409841.7
2DLD Change Limit124790807.20317324.7
3Display Results80800.0461739.1
 (SQL Overall)178691807.68523251.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.