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

95 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
differentiation229211(None) 
differentiating2371792differentiating
differentiate2062933differentiat__e
differentiated2272473differentiat_ed
differentiates2172653differentiat_es
differentia1863534differentia____
differentiable2372204differentia_ble
differentiae1963154differentia___e
differential1963704differentia___l
differentially2463134differentia_lly
differentials2063124differentia__ls
afforestation1962365_afforest_ation
dedifferentiate2391525dedifferentiat__e
defenestration18173545d_efenestration
deforestation1754305d_eforest_ation
disorientation1583775disorient_ation
dissertation1366095disser__t_ation
fermentation1756825___ferment_ation
affectation1943846_aff__ect_ation
afforestations2062246_afforest_ations
bioremediation1961086bioreme_diation
cementation1559706___cement_ation
confrontation1853226conf_ront_ation
decantation1448946d___ecant_ation
decerebration1884196d_ecere_bration
deconcentration20103626deconcentration
decrepitation1884806d__ecrepitation
defeminization2953806d_efeminization
defenestrations1993306d_efenestrations
deferential1554716d_eferentia___l
deferentially2063716d_eferentia_lly
defibrination1953866defibrin__ation
deforestations1853966d_eforest_ations
degeneration1447286d___egeneration
delectation1448556d___elect_ation
dentation10315246d_____ent_ation
dentition1049636d_____enti_tion
denunciation1554536d___enunciation
depigmentation20103046depigment_ation
depreciation1747076d__epre_ciation
derealization231011536d___erealization
deregulation1446086d___eregulation
dereliction1444576d___ere_liction
detestation1248366d___etest_ation
dieselization2356056di__eselization
differencing2252636differen___cing
different1646186differen___t___
differently2193846differen___t_ly
differentness2062386different__ness
differentnesses2271766differentnesses
diffraction2053506diff_r___action
dimerization2449086di_mer__ization
disinfestation18113616disinfest_ation
disorientations1683626disorient_ations
dispensation1555606di__spen_sation
disrelation1248816di__sre__lation
dissemination1655796dissemin__ation
dissertations1465896disser__t_ations
diversification24102786di_versification
documentation18144726d_ocument_ation
effectuation2052286_eff__ectuation
exponentiation2361796_exponentiation
fenestration1596076___fenestration
fermentations1856276___ferment_ations
fomentation1647716___foment_ation
forestation1447006___forest_ation
frequentation2552636__frequent_ation
herniation1348446___her_n_iation
hibernation1644096hi_ber_n__ation
implementation2063156implement_ation
indentation1248376_i__ndent_ation
indifferentist2172196indifferentist___
indifferentists2271876indifferentist__s
inferential1457546_inferentia___l
inferentially1955496_inferentia_lly
infestation1447046_inf__est_ation
infuriation1448246_infur___iation
ingratiation1355806_i_ngr_atiation
instantiation13134066_i_nstantiation
interanimation16136016_interanimation
intergeneration1673396_intergeneration
intermediation17105216_intermediation
interstation12410416_inter_st_ation
miscegenation1863136miscegen__ation
misorientation1693186misorient_ation
overestimation19125146__overestimation
perennation1348086___peren_nation
pigmentation1754486pi__gment_ation
potentiation1455976___potentiation
presentation1448996__present_ation
reafforestation21101476reafforest_ation
referentiality2062176_referentiality
reforestation1654576_reforest_ation
representation16154126represent_ation
underestimation1872256_underestimation

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 Filter178691950241.030173486.4
2DLD Change Limit95024958.03311829.2
3Display Results95950.0761250.0
 (SQL Overall)178691959.13919552.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.