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

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

52 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
deferential155471(None) 
referential1454681referential
deferentially2063712deferentially
differential1963702differential
inferential1457542inferential
preferential1753872preferential
reverential1484462reverential
conferential1755393conferential
deferent122712873deferent___
deferents13269393deferent__s
demential1248693d__emential
differentia1863543differentia_
differentiae1963153differentiae
differentials2063133differentials
referentially1963523referentially
credential1346414_credential
decennial1244824d__ecennial
decremental1654674decrement_al
decretal1146354de_cre_t_al
deference1578494deferen__ce
deferences1677874deferen_ces
deferment151210304deferment___
deferments16128584deferment__s
deferral1244354defer___ral
definientia1552654definientia_
deforesting1654794deforesting
dementia1157834d__ementia_
dementias1257414d__ementias
differentiable2372204differentiable
differentially2463134differentially
differentiate2062934differentiate
elemental1145884_element_al
essential946084_e_ssential
evidential1455464_evidential
experiential2163794experiential
forestial1247234__forestial
inferentially1955494inferentially
influential1473924influential
interferential1763974interferential
penitential1355524penitential
perennial1147234__perennial
preferentially2262834preferentially
referencing1744494referencing
referenda1343074referen_da_
referent112813424referent___
referentiality2062174referentiality
referents12259644referent__s
residential1255284residential
reverentially1963274reverentially
sentential1047554se_ntential
sequential1954824se_quential
torrential1054484_torrential

Search took 9 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 Filter1786911488190.423422437.4
2DLD Change Limit148819528.20318142.0
3Display Results52520.0301733.3
 (SQL Overall)178691528.65620643.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.