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

60 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
frontlets124423(None) 
frontless1235401frontless
frontlet1147651frontlet_
froglets1235262fro_glets
frontes104214162front_e_s
frontiers1254992frontiers
frontlist1246122frontlist
frontlists1344522frontlists
frostless1235742frostless
fruitlets1243172fruitlets
rootlets8308652_rootlets
bractlets1344753bractlets
brooklets1543683brooklets
crosslets1145183crosslets
droplets1136063dro_plets
flatlets1147373f_latlets
fondlers12338023f_ondlers
fondles113512613f_ondle_s
footlers113910793f_ootlers
footles103715713f_ootle_s
footless113710803f_ootless
fretless1138063fr_etless
frockless1843453frockless
froglet11310063fro_glet_
frontages13116183frontages
frontality1654183frontality
frontals1146273front_als
fronted114011273front_e_d
frontenis1243423frontenis
fronter103611583front_e_r
frontier1147313frontie_r
frontline1245053frontline
frontlines1345193frontlines
frontmen1344423frontme_n
frontons1136503front_ons
fronts94415793fron___ts
frosteds12305653frost_eds
frostiest1239213frostiest
frothers14279813fro_thers
fruitless1244163fruitless
fruitlet1146883fruitlet_
gantlets9308903_gantlets
gauntlets1042873gauntlets
gruntles9287233gruntle_s
mantlets104611203_mantlets
moonlets10247473moon_lets
outlets73616363__outlets
plantlets1145013plantlets
printless1137513printless
ringlets92910233_ringlets
rondelets1045263_rondelets
rontgens944683_rontgens
rootles73215633_rootle_s
rootless83910443_rootless
rootlet73015733_rootlet_
roundlets10175293_roundlets
rundlets9307363_rundlets
runlets73310773_run_lets
tonlets73212503_ton_lets
wristlets1244473wristlets

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 Filter1786911486410.420425454.8
2DLD Change Limit148641607.98618612.7
3Display Results60600.0302000.0
 (SQL Overall)178691608.43621182.0
 
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.