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

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

33 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
pestiferousness2081931pestiferousness_
desirousness1356875des_i__rousness_
dexterousness2154625dext__erousness_
floriferousness2191525floriferousness_
odoriferousness1961525odoriferousness_
pestiferous1653025pestiferou____s_
pestiferously2162065pestiferou___sly
prestigiousness1872835presti_giousness_
vociferousness2272355_vociferousness_
boisterousness1662846boist__erousness_
desirousnesses1456866des_i__rousnesses
dexterousnesses2354416dext__erousnesses
fastidiousness1863736fasti_diousness_
fissiparousness1981066fissiparousness_
generousness1356976ge___nerousness_
lecherousness1864076le__cherousness_
lustrousness1255896lust___rousness_
mellifluousness20121176mellifluousness_
meticulousness1872676me_ticulousness_
mysteriousness1953436myst__eriousness_
perfidiousness2054136perfi_diousness_
perilousness1457796pe_ri__lousness_
perniciousness1855316perni_ciousness_
perspicuousness2162256perspi_cuousness_
perviousness1747666pervi___ousness_
piteousness1347266p___ite_ousness_
plenteousness1554556plent__e_ousness_
ponderousness16105336p__onderousness_
posthumousness2162106post_humousness_
prosperousness1862796p_rosperousness_
sulfurousness1653126__sulfurousness_
timorousness1455576___timorousness_
venturousness1655196vent__urousness_

Search took 5 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 Filter178691658740.330541487.9
2DLD Change Limit65874334.59314342.3
3Display Results33330.0331000.0
 (SQL Overall)178691334.95636055.5
 
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.