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 “sylvicultures” 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
sylvicultures216263(None) 
silvicultures1873121silvicultures
sylviculture2062291sylviculture_
silviculture1762802silviculture_
avicultures16154993__avicultures
sericultures1474873s_ericultures
silvicultural1872833silvicultural
silviculturist1972843silviculturist
agricultures1554464_agricultures
apicultures15134914__apicultures
aquicultures23164094_aquicultures
aviculture15144584__aviculture_
citricultures1763914citricultures
floricultures18133264floricultures
horticultures1863614horticultures
maricultures1654914_maricultures
piscicultures1962674piscicultures
sericulture1364634s_ericulture_
silviculturists2082364silviculturists
subcultures1554594s__ubcultures
vinicultures1754014_vinicultures
viticultures1754084_viticultures
agriculture1454045_agriculture_
apiculture14134575__apiculture_
aquacultures23153015_aquacultures
aquiculture22143725_aquiculture_
arboricultures1892025arboricultures
aviculturist17134695__aviculturist
citriculture1663585citriculture_
cocultures1445735___cocultures
cultures10310155_____cultures
floriculture17122975floriculture_
horticulture1763305horticulture_
mariculture1554685_mariculture_
microcultures1964725microcultures
monocultures1653905_monocultures
multicultural1763405multicultural
pisciculture1862505pisciculture_
plicatures1443985_pl_ic_atures
sculptures1443845s____culptures
sepultures1243835s___epultures
sericultural1464425s_ericultural
sericulturist15144235s_ericulturist
silviculturally2381885silviculturally
solicitudes1482885sol_ic_itudes
strictures1246175s_tric__tures
subculture1454425s__ubculture_
subcultured1663275s__ubcultured
sylvinites1642655sylvi_nit__es
sylvites14225845sylvi___t__es
viniculture1653665_viniculture_
viticulture1653685_viticulture_
vultures1137215___v__ultures

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.393454684.5
2DLD Change Limit124790538.39014873.7
3Display Results53530.0301766.7
 (SQL Overall)178691538.81320275.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.