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

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

76 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
countercultural1971741countercultural_
counterculture1862323countercultur__e
countercultures1962233countercultur_es
intercultural1563844__intercultural_
counterfactual2161825counterfactu_al_
interculturally2072325__interculturally
anticultural1465296__ant_icultural_
conjectural2253476co_nje_c__tural_
counterclaim1854756counterc_l___aim
countercurrent1863466countercu__rrent
countercyclical2081076countercyclical_
counterguerilla1871406countergu_erilla
countertrade1556296counter___t_rade
horticultural1863146ho_rt_icultural_
interculture1454296__intercultur__e
monocultural1663166mo_n__ocultural_
multicultural1763406_mult_icultural_
nonagricultural1891526no_nagricultural_
noncultural1354826no_n___cultural_
aquacultural2372347aqu___acultural_
conjecturally2792607co_nje_c__turally
contextual1954337co_nte___xtu_al_
contractual1555037co_nt_r_actu_al_
contralateral1562277co_nt_ralateral_
counterassault1682057counterassau__lt
counterattack2172737counter__at_tack
counterblast1655407counter_bl___ast
counterblockade2671017counter_blockade
countercharge2194297counterc__har_ge
countercharged23113617counterc__harged
countercharges22104117counterc__harges
counterclaimed2163527counterc_l_aimed
counterclaiming2262927counterc_laiming
counterclaims1954447counterc_l__aims
countercoup1774497counterc__ou___p
countercoups1854607counterc__ou__ps
countercries1648997counterc____ries
countercry1745097counterc____r__y
countercurrents1962337countercu_rrents
counterfeiter1874747counterfeiter___
counterfeiters19103747counterfeiter__s
countermeasure18122637countermeasur__e
countermeasures19122297countermeasur_es
counterplan1586777counter_pl___a_n
counterplans1687147counter_pl___ans
counterplay18105607counter_pl___a_y
counterplays1995607counter_pl___ays
counterplea1547037counter_pl____ea
counterpleas1655807counter_pl__ea_s
counterproposal21101337counterproposal_
counterraid1446747counter_____raid
counterrally1755527counter_____rally
counterstain14156787counter__st__ain
counterstate1457037counter__st__ate
counterstream1773737counter__st_ream
counterstreams18102807counter__streams
counterstrike1965297counter__st_rike
counterstroke1954787counter__st_roke
counterstruck2163197counter__st_ruck
counterstyle1755057counter__st__yle
countersuit13137507countersuit_____
countersuits14126587countersuit____s
counterterror1562557counter___terror
counterthreat1854057counter___threat
counterthreats1962877counter___threats
counterthrust1873607counter___thrust
countertrades1655897counter___t_rades
countertrend1575947counter___t_rend
counterworld1854217counter___wor_ld
horticulturally2372137ho_rt_iculturally
nonstructural1573657no_nstr_uctural_
sericultural1464427____sericultural_
sociocultural1772567so__ciocultural_
subcultural1553717_su___bcultural_
transcultural1562277tran__scultural_
viticultural1763587__vit_icultural_

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 Filter178691950240.1401276364.3
2DLD Change Limit95024768.87610705.7
3Display Results76760.0601266.7
 (SQL Overall)178691769.07619688.3
 
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.