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

53 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
documentalist1814489(None) 
documentalists19153951documentalists
documentarist18163971documentarist
documentarists19113122documentarists
documental1554513documental___
documentarian18143033documentarian
documentaries1863263documentaries
documentarily2162643documentarily
documentation18144723documentation
documentable1982514documenta_ble
documentarians19162644documentarians
documentary1953064documenta__ry
documentations19144484documentations
documenters1652814document_ers_
documenting1753124document__ing
documents1446524document___s_
incrementalist18164524incrementalist
mentalist11515554____mentalist
monumentality2063884monumentality
monumentalize26123834monumentalize
orientalist1197824_o_rientalist
sacramentalist1873834sacramentalist
centralist12511065__c__entralist
commensalism1764955co_mmensalism
communalist17116255co_mmun_alist
document1348665documen_____t
documentational2061965documentational
documented1653205document___ed
documenter1553285document___er
ecumenicalism2172115_ecumenicalism
ecumenicist1762835_ecumen_icist
ecumenist13145905_ecumen___ist
fundamentalist20132965fundamentalist
governmentalist21103165governmentalist
incrementalism20154365incrementalism
incrementalists19163635incrementalists
instrumentalist17133575instrumentalist
journalist1755005jo_u_rn_alist
mentalism13511645____mentalism
mentalists12410485____mentalists
metalist10519355____me_talist
monometallist1762955monome_tallist
monumental1455215monumental___
monumentalized28123045monumentalized
monumentalizes27123485monumentalizes
monumentally1953985monumental_ly
nominalist1248165no__min_alist
orientalism13126495_o_rientalism
orientalists12125775_o_rientalists
sacramentalism2073695sacramentalism
sacramentalists1973285sacramentalists
sentimentalist16155455sentimentalist
voluntarist1474415volu__ntarist

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.406440125.6
2DLD Change Limit124790538.17315268.6
3Display Results53530.0461152.2
 (SQL Overall)178691538.62520717.8
 
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.