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

105 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
frontons113650(None) 
fronton1037201fronton_
crotons93714372cro_tons
croutons1036752croutons
frontals1146272frontals
frontenis1243422frontenis
frontes104214162front_es
fronting12310442fronting
fronts94415792front__s
pontons93315552_pontons
protons93118002pro_tons
ronions73313342_ronions
ronyons10258432_ronyons
wontons103310532_wontons
bonbons1139333_bonbons
bostons9312903_bostons
boutons9310783_boutons
broncos11188073bronco_s
cantons95221203_cantons
chronons1347353chron_ons
contos84923233_conto_s
cottons9312193_cottons
cratons94316033cr_atons
croons85418423cro__ons
croton84415453cro_ton_
crouton947133crouton_
donjons1536733_donjons
dromons1038193dro_mons
drongos935493drongo_s
erosions8310343erosions
fanions103713073f_anions
fanons96115213f_an_ons
fantods11177623f_antods
fantoms12189153f_antoms
foetors1039763f_oetors
foisons1047613f_oisons
fontina1038633f_ontina
fontinas1136853f_ontinas
fonts86124753f_ont__s
forenoons1245743forenoons
foretops13137483foretops
fractions1449103fractions
frictions1448033frictions
frissons1145043frissons
frondose1244523frondose
fronds106412343fron__ds
frons86124043fr___ons
front85029223front___
frontage1296243frontage
frontages13116183frontages
frontal1038363front_al
fronted114011273front_ed
fronter103611583front_er
frontier1147313frontier
frontiers1254993frontiers
frontless1235403frontless
frontlet1147653frontlet
frontlets1244233frontlets
frontline1245053frontline
frontlines1345193frontlines
frontlist1246123frontlist
frontman1344303frontman
frontmen1344423frontmen
frosteds12305653frosteds
frosting12311183frosting
frostings1335733frostings
frosts94214623frost__s
froths125411443fro_t_hs
frowns126011393fro__wns
fruitions12106113fruitions
futons93911513f__utons
grantors93810363grantors
grottoes9276753grottoes
grottos8337333grotto_s
grunions945353grunions
ironstone945753ironstone
ironstones1045823ironstones
kroons103711243kro__ons
kryptons1743223kryptons
moutons9410313_moutons
onions64016433__onions
phonons123310253phon_ons
photons123814433pho_tons
ponton83217643_ponton_
pontoons10279313_pontoons
proctors12311513proctors
pronations12314033pronations
pronators11411303pronators
pronouns1047203pronouns
pronto8313993pronto__
proton84318893pro_ton_
rattons73815323_rattons
rhytons13295883_rhytons
rondos74616733_rondo_s
ronion63315643_ronion_
rontgens944683_rontgens
ronyon9309133_ronyon_
rotors64917953_ro_tors
rotos56027883_ro_to_s
sponsons1045813sponsons
spontoons1153403spontoons
tritons73814883tr_itons
trogons83410723tro_gons
wantons103713013_wantons
wonton93410963_wonton_

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.403443402.0
2DLD Change Limit1461621056.73621698.6
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.18524870.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.