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

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

148 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
countermines164915(None) 
countermine1549741countermine_
counterfires1747062counterfires
countermands1746222countermands
countermoves1956012countermoves
counterpanes1649302counterpanes
countersinks1846162countersinks
centerlines1346993c_enterlines
conterminous1653273co_nterminous
counterbids1646013counterbi_ds
countercries1648993countercries
counterfire1647003counterfire_
counterimages1854613counterimages
countering13314473counter_in_g
counterions1349813counter_ions
counterman1448543counterman__
countermand1647113counterman_d
countermanded1974683countermanded
countermemos1854433countermemos
countermen1449293counterm__en
countermove1855853countermove_
countermoved2054993countermoved
countermyths2253553countermyths
counterpane1549313counterpane_
counterpoints1755613counterpoints
counterpoises1756403counterpoises
counterposes1647613counterposes
countersigned1784353countersigned
countersigns1546423countersigns
countersink1748063countersin_k
counterspies1648303counterspies
countersues1348533counter_sues
counterview19116683countervi_ew
counterviews20134873counterviews
countries11313593count_r_i_es
undermines131710663__undermines
cauteries11615364cau_ter_i_es
cauterizes2197994cau_ter_izes
centerings13247654c_enter_ings
centerline1247044c_enterline_
chuntering1647804chunter_in_g
cointerring1447144cointerrin_g
concertinas15107524co_ncertinas
concertinos15158104co_ncertinos
concertizes24158574co_ncertizes
conferments1848324co_nferments
congeries12316394co_nger_i_es
contemned1446794co_nte_m_ned
contemner1347184co_nte_m_ner
contemners1447074co_nte_m_ners
contemns1237404co_nte_m_n_s
contrives14311704co_nt_r_ives
coteries10422704co__ter_i_es
coterminous1552544co__terminous
counselings1442714counse_lings
counsellings1552114counsellings
countenances1655734countenances
counteracted1747364counteracted
counteracts1547494counter_acts
counteragent1557694counteragent
counteragents1655164counteragents
counterargues1685044counterargues
counterbid1546074counterbi__d
counterblows1954214counterblows
counterchanges22124224counterchanges
countercoups1854604countercoups
counterdemands2062394counterdemands
countered12312994counter___ed
counterfeited1974774counterfeited
counterfeiter1874744counterfeiter
counterfeiters19103744counterfeiters
counterfeits1756204counterfeits
counterflows2054354counterflows
counterfoils1755394counterfoils
counterforces2085554counterforces
counterimage1754984counterimage
counterion1249534counter_i_on
countermarch2154464countermarch
countermarches2373744countermarches
countermemo1754724counterm_emo
countermoving2154164countermovin_g
countermyth2153794counterm_yth
counteroffer2054114counteroffer
counteroffers2153264counteroffers
counterorder1555604counterorder
counterorders1654474counterorders
counterparts1646704counterparts
counterpicket2355164counterpicket
counterpickets2463314counterpickets
counterplans1687144counterplans
counterplays1995604counterplays
counterplea1547034counter_plea
counterpleas1655804counterpleas
counterplots16106224counterplots
counterploys1995354counterploys
counterpoint1658174counterpoin_t
counterpointed1953594counterpointed
counterpoise1657354counterpoise_
counterpoised1855304counterpoised
counterpose1547504counterpose_
counterposed1756324counterposed
counterpower1965864counterpower
counterpowers2064824counterpowers
counterpunch2154194counterpunch
counterpunches2383244counterpunches
counterraids1556594counterraids
counters103320184counter____s
countershots1755934countershots
countersign1447244countersi_gn
countersniper17104554countersniper
countersnipers1893274countersnipers
counterstained1754844counterstained
counterstains15156624counterstain_s
counterstates1586644counterstates
counterstep1547114counter_step
countersteps1655884countersteps
counterstrikes2094744counterstrikes
counterstyles1854784counterstyles
countersue1247744counter_sue_
countersued1447074counter_sued
countersuing1547084countersuin_g
countersuits14126584countersuits
countersunk1755264countersun_k
countertenor1454754countertenor
countertenors1554064countertenors
countertops1546354counter_tops
countertrades1655894countertrades
countertrend1575944countertrend
countertrends1674354countertrends
countervailed19154894countervailed
countervails1755984countervails
countesses1248844counte__sses
counties10316274count___i_es
countrysides1852054countrysides
courtesies1246454courte_si_es
coversines15128634co__versines
cysteamines1893384c_ysteamines
determines1358424__determines
extermines1947784__extermines
interlines101116444__interlines
intermixes1948394__intermixes
nonterminal1355304no_nterminal
nonterminals1453634no_nterminals
overmines14312684_o__vermines
redetermines15113414redetermines
underlines111512114__underlines
undermine122012234__undermine_
undermined14189124__undermined

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.1731032896.0
2DLD Change Limit1247901489.28013447.2
3Display Results1481480.0961541.7
 (SQL Overall)1786911489.54918713.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.