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

57 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
differentiating237179(None) 
differentiation2292112differentiation
differentiate2062933differentiat__e
differentiated2272473differentiat_ed
differentiates2172653differentiat_es
differencing2252634differen___cing
differentia1863544differentia____
differentiable2372204differentia_ble
differentiae1963154differentia___e
differential1963704differentia___l
differentially2463134differentia_lly
differentials2063134differentia__ls
dedifferentiate2391525dedifferentiat__e
defenestrating19112545d_efenestrating
disorientating1682715disorient_ating
dissertating1474795disser__t_ating
credentialing17102796__credentialing
decerebrating1953206d_ecere_brating
deconcentrating2163086deconcentrating
decrepitating1953026d__ecrepitating
deferential1554716d_eferentia___l
deferentially2063716d_eferentia_lly
defibrinating2052466defibrin__ating
degenerating1545666d___egenerating
delectating1545996d___elect_ating
depreciating1845036d__epre_ciating
deregulating1554016d___eregulating
different1646186differen___t___
differently2193846differen___t_ly
differentness2062386different__ness
differentnesses2271766differentnesses
differing1746486differ______ing
diffracting2143356diff_r___acting
discrediting1753216di_scre_di_ting
disentailing1484226di___sentailing
disentitling1453636di___sentitling
disfurnishing2161586disfur_n_ishing
disheriting1646456disher___i_ting
disseminating1754056dissemin__ating
effectuating2151786_eff__ectuating
eventuating1543256____eventuating
herniating1445986___her_n_iating
hibernating1753176hi_ber_n__ating
indifferentist2172206indifferentist___
indifferentists2271886indifferentist__s
inferential1457546_inferentia___l
inferentially1955496_inferentia_lly
infuriating1546286_infur___iating
ingratiating1454066_i_ngr_atiating
instantiating1462936_i_nstantiating
interknitting1853286_interkn_itting
intermediating1853986_intermediating
overestimating2054326__overestimating
perennating1445546___peren_nating
potentiating1554286___potentiating
referentiality2062176_referentiality
underestimating1972076_underestimating

Search took 8 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.360496363.9
2DLD Change Limit95024577.22013161.2
3Display Results57570.0301900.0
 (SQL Overall)178691577.61023481.1
 
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.