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

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
differentials206312(None) 
differential1963701differential_
differentia1863522differentia__
differentiable2372202differentiable
differentiae1963152differentia_e
differentially2463132differentially
differentiate2062932differentiate
differentiates2172652differentiates
deferential1554713d_eferential_
differentiated2272473differentiated
differently2193833different__ly
differentness2062383differentness
inferential1457543_inferential_
conferential1755394conferential_
dedifferentiate2391524dedifferentiate
deferentially2063714d_eferentially
differences2054914differen__ces
differencing2252634differenci_ng
different1646174different____
differentiating2371794differentiating
differentiation2292114differentiation
indifferentisms2481774indifferentisms
indifferentists2271874indifferentists
inferentially1955494_inferentially
influentials1583094_influentials
preferential1753874preferential_
referential1454684_referential_
afferently1954005_afferent__ly
afferents1546015_afferent___s
credentials1454715__credentials
decennials1353345d___ecennials
deferents13269395d_eferent___s
demential1248695d___emential_
dementias1257415d___ementia_s
difference1955025differen___ce
differenced2153465differen__ced
differentnesses2271765differentnesses
diffidently2252755diffident__ly
diffractions2153275diff_ractions
disentails1147015di___sentails
efferently1954055_efferent__ly
efferents1545335_efferent___s
indifferencies2362485indifferenci_es
indifferentism2371925indifferenti_sm
indifferentist2172195indifferenti_st
indifferently23132465indifferent__ly
inessentials1263585_inessentials
influential1473915_influential_
perennials1244895___perennials
preferentially2262835preferentially
referentially1963525_referentially
reverential1484465_reverential_

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 Filter1786911247900.390458182.1
2DLD Change Limit124790528.75014261.7
3Display Results52520.0301733.3
 (SQL Overall)178691529.17019486.5
 
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.