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

35 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
differentiate206293(None) 
differentiae1963151differentia_e
differentiated2272471differentiated
differentiates2172651differentiates
dedifferentiate2391522dedifferentiate
differentia1863522differentia__
differentiable2372202differentiable
differential1963702differentia_l
differentials2063122differentials
differentially2463123differentially
differentiating2371793differentiating
differentiation2292113differentiation
deferential1554714d_eferentia_l
difference1955024differen___ce
differencing2252634differenci_ng
different1646174differen___t_
differently2193834different__ly
differentness2062384differentness
indifferentist2172194indifferentist_
indifferentists2271874indifferentists
inferential1457534_inferentia_l
conferential1755385conferentia_l
defenestrate1662645d_efenestrate
deferentially2063705d_eferentially
differenced2153465differen__ced
differences2054915differen__ces
differentnesses2271765differentnesses
disorientate1363385disorient_ate
dissertate1145985disser__t_ate
indifferentism2371925indifferenti_sm
indifferentisms2481775indifferentisms
inferentially1955485_inferentially
licentiate1254805li___centiate
preferential1753875preferentia_l
referential1454685_referentia_l

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 Filter1786911247900.393454684.5
2DLD Change Limit124790357.84315911.0
3Display Results35350.0301166.7
 (SQL Overall)178691358.26621617.6
 
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.