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

175 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
frosteds1230565(None) 
frosted113211871frosted_
fosters104220102f_osters
fronted114011272fronted_
frontes104214162fronte_s
frostless1235742frostless
frosts94214622frost__s
frowsted1534312frowsted_
rosters73727542_rosters
worsteds1234482worsteds
bilsteds1134273bilsteds
boosted104111983boosted_
boosters104013443boosters
broses86524403bros_e_s
costed95623113_costed_
costers94128333_costers
crested103416533crested_
crofters13358903crofters
crosiers103312063crosiers
crossed105313893crossed_
crossers103912703crossers
crosses94220793crosse_s
croutes94815653croute_s
crowsteps1642533crowsteps
crusted103712753crusted_
defrosted1444253defrosted_
defrosters1443363defrosters
drosses84513823drosse_s
eroses65327053eros_e_s
farmsteads1651063farmsteads
fasted105320953f_asted_
fastens105511753f_astens
feasted11310843feasted_
feasters11511563feasters
festers104121393f_esters
fibsters13126413fibsters
fisted104218703f_isted_
floated113312703floated_
floatels11295663floatels
floaters112711513floaters
flossed11388533flossed_
flossers11307863flossers
flosses103411973flosse_s
flouted113210813flouted_
flouters11419273flouters
flusters113811503flusters
foisted113210603foisted_
footed104418623f_ooted_
footers104618333f_ooters
footsteps1462863footsteps
forested12312463forested_
foresters12312533foresters
fortes95327183f_orte_s
fosses96022083f_osse_s
foster94322223f_oste_r
fracted1339373fracted_
frasses104314513frasse_s
fraters103517213fr_aters
freshed143312593freshed_
freshens14298313freshens
freshes133515823freshe_s
freshets14298673freshets
fresnels1135233fresnels
fretted113411853fretted_
fretters113410303fretters
frisbees13295013frisbees
frisees104411693fris_ees
frises94124273fris_e_s
frisked15478823frisked_
friskers15337373friskers
friskets15326263friskets
frites94922483fr_ite_s
fritted113611333fritted_
fritters113810783fritters
frocked17439333frocked_
froes86126693fro__e_s
frogged13408493frogged_
froglets1235263froglets
fronded12388863fronded_
fronds106412343fro__nds
frontals1146273frontals
frontenis1243423frontenis
fronter103611583fronte_r
frontiers1254993frontiers
frontless1235403frontless
frontlets1244233frontlets
frontons1136503frontons
fronts94415793front__s
frost84727833frost___
frostbit1344443frostbit
frostfish1842623frostfish
frostier1148163frostier
frostiest1239213frostiest
frostily1436693frostily
frostiness1336563frostiness
frosting12311183frosting
frostings1335733frostings
frostnip1342413frostnip
frostnips1441933frostnips
frosty124710633frost__y
frothed14288783frothed_
frothers14279813frothers
froths125411443fro_t_hs
frotteur1142503frotteur
frotteurs1242223frotteurs
frowned14348833frowned_
frowners14377933frowners
frowsts13426103frowst__s
fruited11389093fruited_
fruiters11328183fruiters
frustums1342993frustums
ghosted1236273ghosted_
gristers94013403gristers
grossed93812253grossed_
grossers94410973grossers
grosses84517683grosse_s
grouted94111503grouted_
grouters95910083grouters
horstes104516113horste_s
hosted105020343_hosted_
hostels103712313_hostels
hostess103210243_hostess
oersteds934373oersteds
posted93722493_posted_
posters93928013_posters
presters103419003presters
proceeds1335983proceeds
prosed94921093pros_ed_
prosers94219643pros_ers
proses84733473pros_e_s
prospers123012263prospers
prosses94019513prosse_s
prosties101421193prosties
proteas92015123pro_teas
proteids11259943pro_teids
protends113010353pro_tends
proteus92511593pro_teus
rasters74629023_rasters
reseeds84012333_reseeds
rested74430783_rested_
resters74130403_resters
roasted83912663_roasted_
roasters83615933_roasters
roisters83615553_roisters
roosted83211883roosted_
roosters83514663roosters
rooted75424003_rooted_
rooters74522933_rooters
rosed65930343_ros_ed_
roses56445773_ros_e_s
rosets65819953_ros_ets
roster64329083_roste_r
rotes56143903_ro_te_s
rotted74524433_rotted_
rotters74421393_rotters
rottes64524833_rotte_s
rousted84013323_rousted_
rousters84315683_rousters
routed75624333_routed_
routers74822873_routers
routes66129313_route_s
roysters113610533_roysters
rusted75020923_rusted_
trotted83711283trotted_
trotters83310243trotters
trusted83412793trusted_
trustees8339323trustees
trusters83112263trusters
trysted11428273trysted_
trysters11298373trysters
trystes10419993tryste_s
worsted1138013worsted_
wrested113410933wrested_
wresters112711733wresters
zosters163015413_zosters

Search took 8 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.436409841.7
2DLD Change Limit1461621757.42019698.4
3Display Results1751750.0632777.8
 (SQL Overall)1786911757.91922564.8
 
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.