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

44 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
symptomatically296233(None) 
asymptotically2662433asympto__tically
systematically2464103sy_stematically
automatically2077444__automatically
diplomatically2453454_diplomatically
lymphatically2853914lymp__hatically
somatically18411154s____omatically
symbiotically2553934symbio__tically
sympathetically3062534sympathetically
sympatrically2554004symp___atrically
symphonically2854134sympho__nically
symptomatic2254234symptomatic____
achromatically2654695_achromatically
amitotically1946935_amito__tically
aromatically19410665___aromatically
asthmatically2355645__asthmatically
asymptomatic2362185asymptomatic____
axiomatically2756095__axiomatically
chromatically2556945__chromatically
cytostatically2463645cy__tostatically
emblematically2562585_emblematically
emphatically2456435_emp__hatically
hypnotically2555625hy_pno__tically
hypostatically2763815hy_postatically
hypothetically3064395hy_pothetically
idiomatically2155555__idiomatically
impolitically2254615_imp_olitically
mathematically2654655__mathematically
mitotically1849125__mito__tically
numismatically2362645num_ismatically
schematically2555455s__chematically
schismatically2673325s_chismatically
semitonically2074755semito__nically
simplistically2363715simp_listically
sporadically2055345s__p_oradically
statically15411575s___t__atically
stigmatically2154925s__tigmatically
symbolically2453835sym_bo__lically
symmetrically2554365sym___metrically
symptomatology2771135symptomat_ology
synoptically2256165sy__no_ptically
syntactically2354415sy_nt_actically
synthetically2455035sy_nt_hetically
systemically2254155sy_stem__ically

Search took 6 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 Filter178691658740.313570897.8
2DLD Change Limit65874445.17312734.2
3Display Results44440.0301466.7
 (SQL Overall)178691445.51632395.0
 
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.