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

45 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
preferentially226283(None) 
referentially1963521_referentially
deferentially2063712_deferentially
preferential1753872preferentia_l_
reverentially1963272_reverentially
differentially2463133differentially
inferentially1955493_inferentially
presidentially2063223presidentially
referential1454683_referentia_l_
referentiality2062173_referentiality
deferential1554714_deferentia_l_
penitentially1854294p_enitentially
perennially1654604p___erennially
providentially2362324providentially
prudentially1854154pr__udentially
residentially1773844_residentially
reverential1484464_reverentia_l_
conferential1755395conferentia_l_
confidentially2372975confidentially
differentiable2372205differentiable
differential1963705differentia_l_
differentials2063125differentia_ls
elementally1654195__element_ally
essentially1455125__e_ssentially
evidentially1954055__evidentially
experientially2692705_experientially
inferential1457545_inferentia_l_
influentially1962895_influentially
parentally1546205p___arent_ally
pestilentially1982245pestilentially
potentially1656805p___otentially
preferably2044685prefer____ably
prefrontal1552605pref_ront_a_l_
prefrontals1651525pref_ront_a_ls
premaritally1963205premar_it_ally
premillennially2271255premillennially
presentably1855285pr__esent_ably
presidential1554575presidentia_l_
preternaturally20111065preternaturally
preventively2354705pr__eventively
professorially2271885professorially
proverbially2252125prover__bially
reverently1645615_reverent___ly
sequentially2483575_se_quentially
torrentially1553755__torrentially

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.576310227.4
2DLD Change Limit95024459.14010396.5
3Display Results45450.0331363.6
 (SQL Overall)178691459.74918329.2
 
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.