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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

38 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
proliferates175314(None) 
proliferate1653401proliferate_
proliferated1852361proliferated
preliterates1455342preliterates
preliterate1365953preliterate_
proliferating1962363proliferating
proliferation1853033proliferation
proliferations1952703proliferations
proliferative2162353proliferative
vociferates1982543_vociferates
aliterates101510754__aliterates
alliterates11106254_alliterates
deliberates1446794_deliberates
illiterates11115654_illiterates
liberates111012944___liberates
literates91415654___literates
nonliterates1255454nonliterates
obliterates1345124_obliterates
pilferages1642624p_il_ferages
pollenates1246744p_ol_lenates
polymerases1884194p_olymerases
poriferans1552834p_orifera_ns
priorates11410764pr__i_orates
procreates1448154pro_cre_ates
profiteroles1751354profiteroles
profligates1753704profli__gates
prolificacies22131654prolificacies
prolificities2053474prolificities
propionates1545534propi_onates
propitiates1546204propi_tiates
prorates10418074pro____rates
prostrates12411994pro__strates
reiterates10412004_r_eiterates
rotiferans1352584_rotifera_ns
subliterates1453664subliterates
tolerates9312124_tol__erates
vociferate1872914_vociferate_
vociferated2082204_vociferated

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 Filter1786911247900.403443402.0
2DLD Change Limit124790387.03317743.5
3Display Results38380.0132923.1
 (SQL Overall)178691387.44923988.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.