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

(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
counterworlds195346(None) 
counterworld1854221counterworld_
counterfoils1755393counterfoil_s
counterforces2085553counterforces
underworlds1652803__underworlds
afterworlds18101744__afterworlds
centerfolds1752254c_enterfo_lds
counterbids1646034counter__bids
countercoups1854604counterco_ups
countercries1648994counter_cries
counterfires1747064counterfir_es
counterfoil1655204counterfoil__
counterforce1985794counterfor_ce
counterions1349824counterio__ns
countermands1746234counter_mands
countermoved2054994countermoved_
countermoves1956014countermo_ves
counterorder1555614counter_order
counterorders1654474counter_orders
counterparts1646714counterpar_ts
counterpoints1755624counterpoints
counterpoises1756414counterpoises
counterposed1756324counterposed_
counterposes1647624counterpo_ses
counterpowers2064824counterpowers
counterraids1556604counter_raids
counterspells1753464counterspells
counterstyles1854784counterstyles
countertops1546354counterto__ps
countertrade1556294counter_trade
countertrades1655894counter_trades
countertrends1674354countertrends
countervails1755994countervail_s
otherworlds1851404_o_therworlds
underworld1544274__underworld_
afterwords1774205__afterwor_ds
afterworld1782435__afterworld_
butterworts1653165_butterwor_ts
cankerworms2251785c_ankerwor_ms
centerboards1752605c_enterboards
centerfold1652665c_enterfo_ld_
cointerred1346555cointer__red_
contemnors1445245co_ntemnor__s
controls10311395co_nt_r_o_l_s
convertors1549135co_nvertor__s
counsellors1352965counsellor__s
counselors1243655counse_lor__s
counteracted1747365counteracted_
counteracts1547515counter__acts
counteragents1655175counteragents
counterargue1555305counter_argue
counterargues1685045counterargues
counterbid1546085counter__bid_
counterblast1655405counter__blast
counterblasts1754005counterblasts
counterblow1853905counter__blow
counterblows1954215counter_blows
countercharges22104115countercharges
counterchecks2353325counterchecks
counterclaims1954445counterclaims
countercoup1774495counterco__up
countercry1745095counter_cr__y
counterdemands2062395counterdemands
countered12313005counte___red_
counterefforts2282055countereffor_ts
counterfeits1756215counter_feits
counterfire1647005counterfir__e
counterflow1954005counter__flow
counterflows2054355counter_flows
counterimages1854615counterimages
counterion1249535counterio___n
countermand1647125counter_mand_
countermarch2154465countermar_ch
countermarches2373745countermarches
countermelody2162655countermelody
countermemos1854435counter_memos
countermines1649155counter_mines
countermove1855855countermo__ve
countermoving2154165countermoving
countermyths2253555counter_myths
counteroffer2054115counter_offer
counteroffers2153265counteroffers
counterpanes1649305counter_panes
counterpart1547805counterpar__t
counterplan1586775counter__plan
counterplans1687145counter_plans
counterplay18105605counter__play
counterplays1995605counter_plays
counterplea1547035counter__plea
counterpleas1655805counter_pleas
counterplot1596815counter__plot
counterplots16106235counter_plots
counterploy18105205counter__ploy
counterploys1995355counter_ploys
counterpoint1658175counterpo_int
counterpoise1657355counterpo_ise
counterpoised1855305counterpoised
counterpose1547505counterpo__se
counterposing1885445counterposing
counterpower1965865counterpo_wer
counterprotest1864435counterprotest
counterraid1446755counter__raid
counterrallies1683955counterrallies
counterrally1755525counter_rally
counterreforms2162175counterrefor_ms
counters103320195counte___r__s
countershots1755935counter_shots
countersigns1546425counter_signs
countersinks1846165counter_sinks
counterspell1653915counterspel_l
counterspies1648315counter_spies
counterstains15156625counterstains
counterstates1586645counterstates
countersteps1655885counter_steps
counterstream1773735counterstream
counterstreams18102805counterstreams
counterstrike1965295counterstrike
counterstrikes2094745counterstrikes
counterstroke1954785counterstroke
counterstrokes2064625counterstrokes
counterstruck2163195counterstruck
counterstyle1755055counterstyl_e
countersued1447075counter_sued_
countersues1348535counter__sues
countersuits14126595counter_suits
countertenors1554065countertenors
counterterror1562555counterterror
counterterrors1662485counterterrors
counterthreat1854055counterthreat
counterthreats1962875counterthreats
counterthrust1873605counterthrust
counterthrusts1982465counterthrusts
countertop1445845counterto___p
countertrend1575945counter_trend
countervail1655655countervail__
countervailed19154895countervailed
counterviews20134875counter_views
counterweight2263545counterweight
counterweights2372535counterweights
interfolds14126145__interfo_lds
interworks1746705__interwor_ks
netherworlds1961005_netherworlds
otherworld1751975_o_therworld_
overwords16127645_o__verwor_ds
underwoods1545715__underwo_ods
underwools1444435__underwool_s
underworks1845715__underwor_ks
wonderworks2252025wo_nderwor_ks

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.373479064.3
2DLD Change Limit1247901488.56314573.2
3Display Results1481480.0931591.4
 (SQL Overall)1786911489.02919790.8
 
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.