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

85 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
frontals114627(None) 
frontal1038361frontal_
fontal9313142f_ontal_
fractals1346132fractals
frontage1296242frontage
frontages13116182frontages
frontally1546112frontally
frontes104214162front_es
frontons1136502frontons
fronts94415792front__s
rentals74017482_rentals
arousals866273arousals
borstals1037473borstals
brantails1146313brantails
bromals1139743bro_mals
cantals93919573_cantals
centals94317053_centals
confrontals1652673confrontals
coronals103312913coron_als
crystals1347173crystals
dentals83915393_dentals
fantails1139693f_antails
finals94316163f_in_als
finials103210153f_inials
floatels11295663floatels
florals104210063flo_rals
flotas94013003flo_ta_s
foals85721693f_o__als
foetal9311883f_oetal_
fontanels1244063f_ontanels
fonts86124753f_ont__s
formals123312893f_ormals
foxtails1844583f_oxtails
fractal1237623fractal_
fronds106412343fron__ds
frons86124043fron___s
front85029223front___
frontality1654183frontality
fronted114011273front_ed
frontenis1243433frontenis
fronter103611583front_er
frontier1147313frontier
frontiers1254993frontiers
fronting12310443fronting
frontless1235403frontless
frontlet1147653frontlet
frontlets1244233frontlets
frontlist1246123frontlist
frontman1344303frontman
frontmen1344423frontmen
fronton1037203front_on
frontpage15102633frontpage
frontpages1692643frontpages
frontward1642573frontward
frontwards1742343frontwards
frosteds12305663frosteds
frostily1436693frostily
frosts94214623frost__s
froths125411443fro_t_hs
frottage1245083frottage
frottages1384993frottages
fungals11276783f_ungals
horntails12124823horntails
mortals93914013_mortals
orbitals1045713orbitals
orientals946923orientals
pontils9312213_pontils
portals94015563_portals
postals93716383_postals
prefrontals1651523prefrontals
pronates10418373pronates
protyls12298463pro_tyls
quintals17288003quintals
ratals64219583_r_atals
rental63922033_rental_
rondels82510053_rondels
ronnels7318623_ronnels
rotas54827723_ro_ta_s
rotls55620163_ro_t_ls
royals93711263_ro_yals
totals63115163_to_tals
tronas63816903tron_a_s
trotyls10236033tro_tyls
uprootals1142643uprootals
urinals7610263urin_als

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.453394461.4
2DLD Change Limit146162857.21620255.3
3Display Results85850.0501700.0
 (SQL Overall)178691857.71923149.5
 
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.