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

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

95 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
counterdemand196321(None) 
counterdemands2062391counterdemands
countermand1647122counter__mand
counterman1448553counter__man_
countermands1746233counter__mands
countered12313004counter_e___d
counterfeited1974774counterfeited
counterimage1754984counter_image
countermanded1974684counter__manded
countermemo1754724countermem__o
countermemos1854434countermem_os
countermen1449294counter__men_
countermine1549744counter__mine
counterpane1549314counter__pane
counterplan1586774counter_plan_
counterplans1687144counter_plans
counterraid1446754counter__raid
countertrend1575944counter_trend
countryman1753574count_r_yman_
chuntered1536665chunter_e___d
cointerred1346555cointerre___d
confirmand1853225co_nfir__mand
contended1339275co_ntende___d
contraband1553425co_nt_r_aband
cornerman1345365corn_er__man_
counteract1449605counter___act
counteracted1747365counter_acted
counteracting1856285counteracting
counteragent1557695counter_agent
counterargued1754225counterargued
counterattack2172735counterattack
counterbalance20123245counterbalance
counterbalanced22142575counterbalanced
counterbid1546085counter___bid
counterblast1655405counter_blast
counterchange2194865counter_change
counterchanged23103775counter_changed
counterchecked2562645counterchecked
counterclaim1854755counter_claim
counterfeit1657735counterfe__it
counterfeiter1874745counterfeiter
counterfeiting2054025counterfeiting
counterfeits1756215counterfe_its
counterimages1854615counter_images
countering13314475counter___ing
counterion1249535counter__ion_
counterions1349825counter__ions
countermanding2053745counter__manding
countermarch2154465counter__march
countermelody2162655countermelody
countermines1649155counter__mines
countermove1855855counter__move
countermoved2054995counter_moved
countermovement2471815countermovement
countermoving2154165countermoving
countermyth2153795counter__myth
counterordered1862535counterorde_red
counterordering19162415counterordering
counterpanes1649305counter__panes
counterpart1547805counter__part
counterplay18105605counter_pla_y
counterplays1995605counter_plays
counterplea1547035counterplea__
counterpleas1655805counterplea_s
counterpoint1658175counter_point
counterpoised1855305counterpoised
counterposed1756325counter_posed
counterposing1885445counterposing
counterraids1556605counter__raids
counterreform2062585counterreform
countersign1447245counter_sign_
countersigned1784355countersigned
countersigns1546425counter_signs
countersink1748065counter__sink
counterstain14156785counter_stain
counterstained1754845counterstained
counterstains15156625counterstains
counterstate1457035counter_state
counterstated1665635counterstated
countersued1447075counter__sued
countersuing1547085counter_suing
countersunk1755265counter__sunk
countertenor1454755counterte_nor
countertenors1554065countertenors
counterterror1562555counterterror
countertrade1556295counter_trade
countertrends1674355counter_trends
countervail1655655counter__vail
countervailed19154895countervailed
counterweight2263545counterweight
counterworld1854225counter_world
countrymen1753895count_r_ymen_
countrywoman2281595countrywoman_
interdepend15124125__interdepend
nondemand1344755no_n___demand

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 Filter1786911247900.406440125.6
2DLD Change Limit124790958.98613887.2
3Display Results95950.0601583.3
 (SQL Overall)178691959.45218905.1
 
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.