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

50 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
voraciousnesses20146151voraciousnesses_
veraciousnesses20156502veraciousnesses_
graciousnesses1757693_graciousnesses_
vivaciousnesses2364753vivaciousnesses_
voraciousness18116733voraciousne_s_s_
atrociousnesses1754824atrociousnesses_
audaciousnesses1855134audaciousnesses_
capaciousnesses2195434capaciousnesses_
consciousnesses1855784consciousnesses_
ferociousnesses2055814ferociousnesses_
fractiousnesses2075844_fractiousnesses_
preciousnesses1857504_preciousnesses_
rapaciousnesses19105444rapaciousnesses_
sagaciousnesses1765214sagaciousnesses_
salaciousnesses1665574salaciousnesses_
spaciousnesses17147154_spaciousnesses_
tenaciousnesses1756044tenaciousnesses_
vacuousnesses1896484v__acuousnesses_
variousnesses1648634v__ariousnesses_
veraciousness1897274veraciousne_s_s_
vexatiousnesses2555244vexatiousnesses_
vicariousnesses2085044vicariousnesses_
viciousnesses1848014v__iciousnesses_
copiousnesses1747775co__piousnesses_
curiousnesses1548985cur__iousnesses_
deliciousnesses1855845deliciousnesses_
egregiousnesses1764245egregiousnesses_
factiousnesses1977485__factiousnesses_
gloriousnesses1556885glor__iousnesses_
gorgeousnesses1655095gor_geousnesses_
graciousness1548405_graciousne_s_s_
hilariousnesses1864865hilariousnesses_
judiciousnesses2584735judiciousnesses_
lusciousnesses1556215_lusciousnesses_
maliciousnesses19195955maliciousnesses_
noxiousnesses2047145no__xiousnesses_
obviousnesses1866265_o_bviousnesses_
odiousnesses1347965_o__diousnesses_
officiousnesses2364265officiousnesses_
perviousnesses1957245per_viousnesses_
porousnesses1469275por___ousnesses_
previousnesses1966455_previousnesses_
raucousnesses1556525__raucousnesses_
seriousnesses1249845ser__iousnesses_
speciousnesses17146875_speciousnesses_
tortuousnesses1455765tor_tuousnesses_
uxoriousnesses2156285uxor__iousnesses_
virtuousnesses1795295vir_tuousnesses_
viscousnesses1785985v_isc_ousnesses_
vivaciousness2154845vivaciousne_s_s_

Search took 3 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 Filter178691435480.0762351197.4
2DLD Change Limit43548502.81315481.0
3Display Results50500.0301666.7
 (SQL Overall)178691502.91961216.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.