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

123 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
fronton103720(None) 
frontons1136501frontons
croton84415452cro_ton
crouton947132crouton
front85029222front__
frontal1038362frontal
fronted114011272fronted
fronter103611582fronter
frontes104214162frontes
fronting12310442fronting
frontman1344302frontman
frontmen1344422frontmen
fronts94415792front_s
ponton83217642_ponton
pronto8313992pronto_
proton84318892pro_ton
ronion63315642_ronion
ronyon9309132_ronyon
wonton93410962_wonton
bonbon10310073_bonbon
boston8513043_boston
bouton8311533_bouton
bronco10179493bronco_
broncos11188073broncos
canton85722993_canton
chronon1237353chron_on
conto76027173_conto_
contos84923233_contos
cotton8312993_cotton
craton84517193cr_aton
croon75522783cro__on
crotons93714373cro_tons
croutons1036753croutons
donjon1436463_donjon
dromon939363dro_mon
drongo836793drongo_
drongos935493drongos
erosion7311123erosion
fanion94514323f_anion
fanon84619013f_an_on
fantod102010033f_antod
fantom112110803f_antom
foetor939563f_oetor
foison948933f_oison
font77143753f_ont__
fontal9313143f_ontal
fontina1038633f_ontina
fonts86124753f_ont_s
forenoon1146823forenoon
foretop12117893foretop
fraction1359483fraction
frantic12310373frantic
friction1347913friction
frisson1045313frisson
frogman1335873frogman
frogmen1335893frogmen
frond95316343fron__d
fronded12388863fronded
frondose1244523frondose
fronds106412343fron_ds
frons86124043fron__s
frontage1296243frontage
frontals1146273frontals
frontenis1243433frontenis
frontier1147313frontier
frontlet1147653frontlet
frontline1245053frontline
frost84727833frost__
frosted113211883frosted
frosting12311183frosting
frosts94214623frost_s
frosty124710633frost_y
froth115919283fro_t_h
froths125411443fro_ths
frothy15578373fro_thy
frown115415973fro__wn
frozen18408443fro_zen
fruition11106103fruition
futon83113773f__uton
gonion73612833_gonion
grantor84010943grantor
grotto7349813grotto_
grottos8337333grottos
grunion835433grunion
ironman936613ironman
ironmen936453ironmen
ironstone945753ironstone
kronen10348913kron_en
kronor10417233kron_or
kroon94514483kro__on
krypton1643283krypton
mouton8410853_mouton
onion54320973__onion
onto46127663__onto_
phonon114012033phon_on
photon1111514833pho_ton
pontons93315553_pontons
pontoon93010703_pontoon
prenoon9310043prenoon
proctor11310433proctor
pronation11415703pronation
pronator10311783pronator
pronota939763pronota
pronoun939033pronoun
protons93118003pro_tons
prounion1046823prounion
ratton64116123_ratton
rhyton12356113_rhyton
rondo65218373_rondo_
rondos74616733_rondos
ronions73313343_ronions
rontgen835173_rontgen
ronyons10258433_ronyons
roto45935053_ro_to_
rotor55519733_ro_tor
rotos56027883_ro_tos
rotten64115433_rotten
sponson935383sponson
spontoon1043783spontoon
triton63914893tr_iton
trogon73611753tro_gon
wanton94413813_wanton
wontons103310533_wontons

Search took 7 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 Filter1786911340270.393454684.5
2DLD Change Limit1340271236.20321606.8
3Display Results1231230.0462673.9
 (SQL Overall)1786911236.64226903.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.