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

88 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
frosted113211881frosted_
frosteds12305661frosteds
fronted114011272fronted_
frostbit1344442frostbit
frostiest1239222frostiest
frowsted1534322frowsted_
boosted104111983boosted_
costed95623123_costed_
crested103416543crested_
crossed105313903crossed_
crossest1012012123crossest
crusted103712763crusted_
defrosted1444263defrosted_
fasted105320953f_asted_
fastest102413723f_astest
feasted11310843feasted_
fisted104218703f_isted_
floated113312703floated_
flossed11388533flossed_
flouted113210813flouted_
foisted113210603foisted_
footed104418623f_ooted_
forested12312463forested_
forspent1348163forspent
foster94322223f_oste_r
fosters104220103f_osters
fracted1339373fracted_
freshed143312593freshed_
freshest143010583freshest
freshet133416643freshe_t
fretted113411853fretted_
frisked15478823frisked_
frisket143811773friske_t
fritted113611333fritted_
frocked17439333frocked_
frogged13408493frogged_
froglet11310063frogle_t
fronded12388863fronded_
fronter103611583fronte_r
frontes104214163fronte_s
frontlet1147653frontlet
frost84727833fros___t
frostbite1443413frostbite
frostier1148163frostier
frostily1436693frostily
frosting12311183frosting
frostless1235743frostless
frostnip1342413frostnip
frosts94214623frost__s
frosty124710633frost__y
frothed14288783frothed_
frotteur1142503frotteur
frowned14348833frowned_
frowsiest1535063frowsiest
frowstiest1643093frowstiest
fruited11389093fruited_
ghosted1236273ghosted_
grossed93812263grossed_
grossest93810093grossest
grouted94111503grouted_
hosted105020343_hosted_
mostest9314793_mostest
posted93722493_posted_
prosect11313393pros_ect
prosed94921103pros_ed_
prosiest10416523prosiest
prospect1447893prospect
protect11313633pro_tect
protest9317533pro_test
rested74430783_rested_
roasted83912673_roasted_
roosted83211893roosted_
rooted75424003_rooted_
rosed65930353_ros_ed_
roset55945243_ros_e_t
rosiest73919213_rosiest
roster64329083_roste_r
rosters73727553_rosters
rotted74524433_rotted_
rousted84013333_rousted_
routed75624333_routed_
rusted75020923_rusted_
trotted83711283trotted_
trusted83412793trusted_
trysted11428273trysted_
worsted1138013worsted_
worsteds1234493worsteds
wrested113410933wrested_

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 Limit146162887.95318378.2
3Display Results88880.0302933.3
 (SQL Overall)178691888.40621257.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.