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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
derivations1561149(None) 
deprivations1897921deprivations
derivation14712781derivation_
decimations16410162decimations
dedications15310872dedications
depilations14310902depilations
depravations1885372depravations
deprivation1788772deprivation_
derivational1654262derivational
derivatives1844642derivatives
derivatizes2445152derivatizes
derogations1349392derogations
deviations14311162devi_ations
nervations1359482ner_vations
privations15310102_privations
seriations10316682seri_ations
activations1669263activations
aerations9317903aer__ations
aestivations1547483aestivations
darnations1138413dar_nations
deactivations19175063deactivations
deaerations12311673deaerations
dealations11311373de_alations
deaminations151010133deaminations
decimation15411623decimation_
declinations15410223declinations
decorations14312883decorations
dedication14311963dedication_
defamations1745893defamations
defecations1779003defecations
definitions1545603definitions
deflations1439713de_flations
degradations1544553degradations
deifications18410653deifications
delations102616593de__lations
delegations1348033delegations
delineations1346763delineations
denegations1348543denegations
denervations1657093denervations
denigrations1447353denigrations
denotations1239853denotations
dentations11413633de_ntations
denudations1346343denudations
deoxidations2145243deoxidations
depictions1546893depi_ctions
depilation13312033depilation_
depravation1785693depravation_
deprecations1748563deprecations
depredations1646733depredations
deputations1448343deputations
deracinations1647833deracinations
derisions1038843deri__sions
derivates13310093derivat__es
derivative1746683derivati_ve
derivatize2345983derivati_ze
derivatized2554513derivatized
derivatizing2654823derivatizing
derogation12410393derogation_
desiccations1755653desiccations
designations1456943designations
desolations12310593desolations
destinations13412663destinations
detonations1239373detonations
detritions1148953detri__tions
deviation13312393devi_ation_
devotions1356593de__votions
dilations102614453d__ilations
dimerizations2548543dimerizations
divinations15128413divinations
dominations14611043dominations
dubitations1456673dubitations
durations10311463dur__ations
elevations1338633_elevations
enervations1478573ener_vations
epilations12311713_epilations
estivations1449273estivations
geminations14139263geminations
germinations15137943germinations
herniations1447403herniations
hesitations1448543hesitations
irrigations1246943irrigations
irritations1147833irritations
levigations1546213levigations
levitations1448293levitations
marinations13411273marinations
mediations13310983medi_ations
medications1649933medications
meditations1449333meditations
metrications1649833metrications
motivations1647093motivations
nervation12610243ner_vation_
permeations1549883permeations
perorations13314063perorations
pervasions1545663per_vasions
privation14311173_privation_
recitations13314203recitations
renovations1448423renovations
salivations1448733salivations
seriation9318063seri_ation_
serrations10313103ser_rations
striations10312793stri_ations
terminations14149763terminations
titivations1446263titivations
urinations10310693_urinations
variations13310773vari_ations
vernations13310333ver_nations

Search took 7 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 Filter1786911216330.390458182.1
2DLD Change Limit1216331065.97020374.0
3Display Results1061060.110963.6
 (SQL Overall)1786911066.47027618.4
 
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.