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

23 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
presynaptically2771791presynaptically_
synaptically2255424___synaptically_
pleonastically2154105ple_onastically_
presynaptic2081855presynaptic_____
prismatically2295855pris_ma_tically_
synoptically2256165___synoptically_
aeronautically1954226_aeronautically_
asyndetically2283556__asyndetically_
cryptically2346496cr__y__ptically_
dynastically2155726___dynastically_
frenetically2056336fre__n_etically_
pedantically2056856p_e__dantically_
pneumatically2255466pne_uma_tically_
practically20410446pr____actically_
pragmatically2356266pr_agma_tically_
prenatally1544996pre__na_t__ally_
presidentially2063216presidenti_ally_
proleptically2256006pr__oleptically_
prosaically1847846pros__a__ically_
prosthetically2454616pros_thetically_
psychotically2855816p__sychotically_
syndetically2165506___syndetically_
syntactically2354416___syntactically_

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 Limit65874236.17310671.3
3Display Results23230.0131769.2
 (SQL Overall)178691236.54627297.7
 
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.