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

111 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
countersigns154642(None) 
countersign1447241countersign_
counterions1349822counter_ions
countersigned1784352countersigned
countersink1748062countersi_nk
countersinks1846162countersinks
conversions1648273co_nversions
counterbids1646033counterbi_ds
counterfires1747063counterfires
countering13314473counter_i_ng
counterion1249533counter_ion_
countermine1549743countermi_ne
countermines1649153countermines
counterplans1687143counterplans
countershots1755933countershots
countersigning1863223countersigning
counterspies1648313counterspies
counterstains15156623counterstains
countersteps1655883countersteps
countersues1348533counters_ues
countersuing1547083countersuing
countersuits14126593countersuits
countersunk1755263counters_unk
counterviews20134873counterviews
undersigns1265833__undersigns
centerings13247664c_enter_ings
chuntering1647804chunter_i_ng
codesigns1353664co__de_signs
cointerring1447144cointerri_ng
concessions15128104co_ncessions
confessions16136634co_nfessions
consigns1137534co_n___signs
contentions13412094co_ntentions
contortions1348684co_ntortions
contusions1246994co_nt_usions
conversing16310544co_nversi_ng
conversion1548424co_nversion_
counselings1442714counse_lings
counsellings1552114counsellings
counteractions1855024counteractions
counteracts1547514counter_acts
counteragent1557694counteragent
counteragents1655174counteragents
counterargue1555304counterargue
counterargues1685044counterargues
counterbid1546084counterbi__d
counterblows1954214counterblows
countercoups1854604countercoups
countercries1648994countercries
counterfeits1756214counterfeits
counterfire1647004counterfi_re
counterflows2054354counterflows
counterfoils1755394counterfoils
counterimages1854614counterimages
counterman1448554counter_man_
countermand1647124counter_mand
countermands1746234countermands
countermemos1854434countermemos
countermen1449294counter_men_
countermoves1956014countermoves
countermyths2253554countermyths
counterpane1549314counter_pane
counterpanes1649304counterpanes
counterparts1646714counterparts
counterplan1586774counterplan_
counterplays1995604counterplays
counterpleas1655804counterpleas
counterplots16106234counterplots
counterploys1995354counterploys
counterpoint1658174counterpoint
counterpoints1755624counterpoints
counterpoises1756414counterpoises
counterposes1647624counterposes
counterposing1885444counterposi_ng
counterraids1556604counterraids
counters103320194counter____s
countershadings2272704countershadings
countershot1656634counters_hot
countersinking2163484countersinking
countersniper17104554countersniper
countersnipers1893274countersnipers
counterspell1653914counterspell
counterspells1753464counterspells
counterspy1744664counters__py
counterstain14156784counterstain
counterstate1457034counterstate
counterstates1586644counterstates
counterstep1547114counters_tep
counterstrikes2094744counterstrikes
counterstyle1755054counterstyle
counterstyles1854784counterstyles
countersue1247744counters__ue
countersued1447074counters_ued
countersuit13137504counters_uit
countertops1546354counter_tops
countertrend1575944countertrend
countertrends1674354countertrends
countervails1755994countervails
counterview19116684countervi_ew
counterweight2263544counterweight
counterweights2372534counterweights
countess103710054counte_s___s
countesses1248844counte_s_ses
countians1147334count___ians
countries11313614count_r_i_es
countrysides1852054countrysides
coursings12235874cou___rsings
courtesans1244254courte_s_ans
courtesies1246454courte_si_es
outdesigns1251664_ou_tdesigns
undersign1177114__undersign_

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.390458182.1
2DLD Change Limit1247901116.86018191.0
3Display Results1111110.0761460.5
 (SQL Overall)1786911117.32624391.3
 
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.