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

83 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
frothily174530(None) 
filthily1743662filthily
foothill1444992foothill
frostily1436692frostily
frothier1435952frothier
frothing15208532frothing
frothy15578372froth__y
frowzily2642672frowzily
toothily1445522toothily
worthily1745252worthily
wrathily1744772wrathily
artily92814713ar_t_ily
blotchily1942683blotchily
botchily1864373_botchily
breathily1744063breathily
broodily1445503broodily
brothel12318193brothel_
brothels13277073brothels
brotherly1743793brotherly
brothy14519623broth__y
croakily1744733croakily
croupily1544743croupily
dottily1147283_dottily
droopily1443943droopily
drowsily1583723drowsily
earthily1445613earthily
fattily13379463f_attily
fifthly1943093fifth_ly
fishily1637643f_ishily
flashily1735473flashily
fleshily1744533fleshily
floppily1843773floppily
flossily1434523flossily
foamily1546543f_oamily
foggily1535053f_oggily
foothills1544133foothills
foothold1545203foothold
fortify1636523fort_ify
fortuity1465573fortuity
foxily1947253f_o_xily
freakily1835003freakily
frenzily2343733frenzily
freshly16286833fresh_ly
friskily1834503friskily
frizzily2253143frizzily
frontally1546113frontally
froth115919283froth___
frothed14288783froth_ed
frother133110153froth_er
frothers14279813frothers
frothiest1537453frothiest
froths125411443froth__s
frozenly2343123frozenly
fruitily1445143fruitily
frumpily1843323frumpily
fustily133111373fust_ily
grittily1244183grittily
groggily1443283groggily
grouchily1842843grouchily
knottily1543153knottily
mouthily1645903mouthily
pithily1567033_pithily
prettily1337283prettily
prosily12611633pro_sily
ritzily1945143_ritzily
roily86121113_ro__ily
roomily1237283_roomily
ropily113312443_ro_pily
rosily93914713_ro_sily
roupily1246653_roupily
rowdily1436083_rowdily
ruttily10338613_ruttily
snottily1145553snottily
soothly13186923sooth_ly
sootily101810523soot_ily
spottily1335153spottily
trashily1437323trashily
trochil1258713trochil_
trochili1376943trochili
trochils1388583trochils
trothing122410843trothing
xerophily2445013xerophily
zoophily2544913zoophily

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit146162838.32617554.9
3Display Results83830.0332515.2
 (SQL Overall)178691838.78220347.4
 
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.