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

60 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
ferociousnesses205582(None) 
atrociousnesses1754832atrociousnesses
feloniousnesses1855132feloniousnesses
ferociousness1856742ferociousne_s_s
veraciousnesses20156512veraciousnesses
deliciousnesses1855853deliciousnesses
fractiousnesses2075853f_ractiousnesses
graciousnesses1757703_graciousnesses
melodiousnesses1855033melodiousnesses
perviousnesses1957243per_viousnesses
preciousnesses1857513_preciousnesses
seriousnesses1249853ser__iousnesses
tenaciousnesses1756053tenaciousnesses
voraciousnesses20146163voraciousnesses
atrociousness1555574atrociousne_s_s
audaciousnesses1855144audaciousnesses
capaciousnesses2195444capaciousnesses
consciousnesses1855794consciousnesses
copiousnesses1747774__copiousnesses
curiousnesses1548984cur__iousnesses
decorousnesses1756554deco_rousnesses
deliriousnesses1656034deliriousnesses
deviousnesses1747704de__viousnesses
egregiousnesses1764244egregiousnesses
enormousnesses1655844_enormousnesses
enviousnesses1647854_e_nviousnesses
erroneousnesses1583284erroneousnesses
facetiousnesses2055304facetiousnesses
factiousnesses1977494f_actiousnesses
feloniousness1655594feloniousne_s_s
gloriousnesses1556894_gloriousnesses
innocuousnesses17104074innocuousnesses
judiciousnesses2584744judiciousnesses
laboriousnesses1755274laboriousnesses
lusciousnesses1556224_lusciousnesses
maliciousnesses19195964maliciousnesses
mercifulnesses2154264mer_cifulnesses
nervousnesses1646864ner__vousnesses
noxiousnesses2047144__noxiousnesses
obnoxiousnesses2483844obnoxiousnesses
odiousnesses1347964___odiousnesses
officiousnesses2364274officiousnesses
penuriousnesses1756624penuriousnesses
perilousnesses1667234per_ilousnesses
previousnesses1966454_previousnesses
rapaciousnesses19105454rapaciousnesses
religiousnesses1655544religiousnesses
sagaciousnesses1765224sagaciousnesses
salaciousnesses1665584salaciousnesses
seditiousnesses1555644seditiousnesses
spaciousnesses17147164_spaciousnesses
speciousnesses17146884_speciousnesses
tediousnesses1447734te__diousnesses
uxoriousnesses2156284_uxoriousnesses
variousnesses1648644var__iousnesses
venomousnesses1954974veno_mousnesses
veraciousness1897274veraciousne_s_s
vexatiousnesses2555254vexatiousnesses
viciousnesses1848024__viciousnesses
vivaciousnesses2364764vivaciousnesses

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 Limit43548602.72016010.3
3Display Results60600.0461304.3
 (SQL Overall)178691602.84262875.1
 
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.