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

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
frothinesses184559(None) 
filthinesses1844462filthinesses
frostinesses1546532frostinesses
frothiness1645722frothine_s_s
growthinesses2042602growthinesses
worthinesses1845762worthinesses
artinesses10815213ar_t_inesses
artsinesses1138713ar_tsinesses
brattinesses1466263brattinesses
breathinesses1853673breathinesses
broodinesses1544743broodinesses
dottinesses1238133_dottinesses
drowsinesses1644383drowsinesses
earthinesses1545823earthinesses
fattinesses14118973f_attinesses
fishinesses17107243f_ishinesses
flashinesses18124863flashinesses
fleshinesses18114363fleshinesses
floppinesses1942953floppinesses
foaminesses1658073f_oaminesses
fogginesses1645493f_ogginesses
forkinesses1848003f_orkinesses
foxinesses20127733f_o_xinesses
fozinesses22158193f_o_zinesses
freakinesses1945593freakinesses
freshnesses1746103fresh_nesses
friskinesses1944773friskinesses
frizzinesses2342933frizzinesses
frozennesses2443223frozennesses
fruitinesses1546443fruitinesses
fustinesses14129783fust_inesses
grittinesses1345843grittinesses
grogginesses1544073grogginesses
grouchinesses1942653grouchinesses
growlinesses1644723growlinesses
knottinesses1643913knottinesses
pithinesses1637503_pithinesses
portlinesses1446993portlinesses
pottinesses1339103_pottinesses
prettinesses1447543prettinesses
prosinesses13310853pro_sinesses
ritzinesses2096743_ritzinesses
rockinesses1737363_rockinesses
roominesses1337433_roominesses
rootinesses1139523_rootinesses
ropinesses121311023_ro_pinesses
rosinesses101213143_ro_sinesses
rowdinesses1536963_rowdinesses
ruttinesses11128993_ruttinesses
snottinesses1255843snottinesses
sootinesses11410053soot_inesses
spottinesses1445683spottinesses
trashinesses1546113trashinesses

Search took 4 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 Limit95024533.29628830.1
3Display Results53530.0301766.7
 (SQL Overall)178691533.68648478.3
 
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.