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

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

42 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
silviculturists208236(None) 
silviculturist1972841silviculturist_
aviculturists18143523__aviculturists
citriculturists1972783citriculturists
sericulturists16133343s_ericulturists
silvicultures1873123silvicultur__es
viticulturists1972983vi_ticulturists
agriculturists1793334_agriculturists
apiculturists17133594__apiculturists
aviculturist17134694__aviculturist_
citriculturist1873504citriculturist_
floriculturists20102384floriculturists
horticulturists20102944horticulturists
mariculturists1873284_mariculturists
sericulturist15144234s_ericulturist_
silvicultural1872834silvicultur__al
silviculturally2381884silviculturally
silviculture1762804silvicultur___e
sylvicultures2162634sylvicultur__es
viticulturist1863624vi_ticulturist_
agriculturist1694215_agriculturist_
apiculturist16134575__apiculturist_
aquaculturists2571855_aquaculturists
culturists1245415_____culturists
floriculturist19102865floriculturist_
horticulturist1993565horticulturist_
mariculturist1764285_mariculturist_
sylviculture2062295sylvicultur___e
aquaculturist2472246_aquaculturist_
avicultures16154996__avicultur__es
caricaturists1762646_caric_aturists
citricultures1763916citricultur__es
culturist1178096_____culturist_
militarists13116316mil_i___tarists
miniaturists1452686mi_ni__aturists
particularists1884306particul_arists
piscicultures1962676piscicultur__es
secularists13165456s___ecul_arists
sericultures1474876s_ericultur__es
silhouettists16141146sil_houet_tists
vinicultures1754016vi_nicultur__es
viticultures1754086vi_ticultur__es

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 Filter178691950240.360496363.9
2DLD Change Limit95024427.45312749.8
3Display Results42420.0331272.7
 (SQL Overall)178691427.84622774.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.