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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

134 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
frostily143669(None) 
crustily13328172crustily
feistily1445262feistily
flossily1434522flossily
friskily1834502friskily
frostier1148162frostier
frosting12311182frosting
frosty124710632frost__y
frothily1745302frothily
frowzily2642672frowzily
fruitily1445142fruitily
fustily133111372f_ustily
prosily12611632pros_ily
rosily93914712_ros_ily
rustily103112992_rustily
trustily11257102trustily
apostil947903apostil_
apostils1046773apostils
artily92814713ar__tily
bossily1237563_bossily
brassily1336623brassily
bristly12178063brist_ly
broodily1445503broodily
chestily1645523chestily
cosily113613853_cos_ily
costly114012333_cost_ly
craftily1644783craftily
crispily1574693crispily
croakily1744733croakily
crossly1277273cros_sly
crostini1038293crostini
crostino1038883crostino
croupily1544743croupily
crusily12199093crus_ily
dottily1147283_dottily
draftily1534413draftily
dressily1246443dressily
droopily1443943droopily
drowsily1583723drowsily
dustily113211523_dustily
erosely1038083eros_ely
fattily13379463f_attily
faultily1474523faultily
firstly1335643first_ly
fishily1637643f_ishily
flashily1735473flashily
fleshily1744533fleshily
flintily1434893flintily
floppily1843773floppily
foamily1546543f_oamily
foggily1535053f_oggily
fortify1636523f_ortify
fossil9379353f_ossil_
fossils10379013f_ossils
foxily1947253f_o_xily
franticly1744013franticly
freakily1835003freakily
frenzily2343733frenzily
freshly16286833fres_hly
frizzily2253143frizzily
frontal1038363frontal_
frontally1546113frontally
frontals1146273frontals
frontier1147313frontier
fronting12310443fronting
frost84727833frost___
frostbit1344443frostbit
frostbite1443413frostbite
frosted113211873frost_ed
frosteds12305653frosteds
frostfish1842623frostfish
frostiest1239213frostiest
frostings1335733frostings
frostline1245883frostline
frostnip1342413frostnip
frostnips1441933frostnips
frosts94214623frost__s
frothy15578373fro_t_hy
frowstier1553143frowstier
frowsting1634683frowsting
frowsty16464983frowst__y
frozenly2343123frozenly
fructify1942353fructify
frumpily1843323frumpily
frustule1154483frustule
fussily13267603f_ussily
ghostly14355103ghost_ly
glossily1235093glossily
goutily1137933_goutily
grassily1236433grassily
gristly11187333grist_ly
grittily1244183grittily
groggily1443283groggily
grossly1175983gros_sly
gustily113010903_gustily
hastily133010663_hastily
horsily1338843hors_ily
hostile10312553_hostile
hostly124210863_host_ly
joltily1746323_joltily
knottily1543153knottily
loftily1336353_loftily
lustily103611243_lustily
mistily122612343_mistily
mostly113110943_most_ly
mustily123613633_mustily
nastily103011033_nastily
nosily93712683_nos_ily
prettily1337283prettily
prissily1346693prissily
prostie91617743prosti_e
prosties101421193prosties
prostyle13187273prostyle
riskily1436413_riskily
roily86121113_ro__ily
roomily1237283_roomily
ropily113312443_ro_pily
rosiny94414533_ros_iny
roupily1246653_roupily
rowdily1436083_rowdily
rusticly1345183_rusticly
ruttily10338613_ruttily
snootily1136253snootily
snottily1145553snottily
sootily101810523_sootily
sportily1337733sportily
spottily1335153spottily
tastily103311643_tastily
testily102910803_testily
throatily1543703throatily
trashily1437323trashily
urostyle11173953urostyle
yeastily1444573yeastily
zestily19167563_zestily

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.406440125.6
2DLD Change Limit1461621347.54619369.5
3Display Results1341340.0632127.0
 (SQL Overall)1786911348.01522294.6
 
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.