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

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

40 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
sycophantically3062561sycophantically_
sycophantishly307754sycophanti_shly_
lymphatically2853915ly_mpha_tically_
sophistically2356495s__ophistically_
stochastically2463815s_tochastically_
sycophantic2353435sycophantic_____
sycophantly2461935sycophant____ly_
symphonically2854135sy_mphon_ically_
synoptically2256165synop___tically_
cephalically2453876__cepha_lically_
chaotically2148456__c__haotically_
cytoplasmically2971346cytoplasmically_
cytostatically2463646cytosta_tically_
emphatically2456436__empha_tically_
hypostatically2763816hyposta_tically_
hypothetically3064396hypoth_etically_
mechanically2455596mec__han_ically_
monophonically2663416monophon_ically_
necromantically2463046necromantically_
phatically20411316____pha_tically_
prophetically2577456_proph_etically_
psychotically2855816psyc__h_otically_
romantically1948016__ro_mantically_
saprophytically3062236saproph_ytically_
schematically2555456s_chema_tically_
scholastically2454156s_cholastically_
semantically1957886s___emantically_
somatically18411156s__o_ma_tically_
spastically1848736s___p_astically_
sycophancy2552096sycophan__c___y_
sycophantish2561926sycophanti____sh
sycophantism2462186sycophanti____sm
sycophantisms2561956sycophanti___sms
sympatrically2554006sy_mp_atrically_
synaptically2255426sy___naptically_
syntactically2354416sy__ntactically_
synthetically2455036sy_nth_etically_
systematically2464106systema_tically_
unemphatically2673056unempha_tically_
unromantically2164426unro_mantically_

Search took 7 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.360496363.9
2DLD Change Limit65874405.79611365.4
3Display Results40400.0331212.1
 (SQL Overall)178691406.18928872.4
 
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.