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

148 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
frontal103836(None) 
fontal9313141f_ontal
frontals1146271frontals
foetal9311882f_oetal
fractal1237622fractal
front85029222front__
frontage1296242frontage
frontally1546112frontally
fronted114011272fronted
fronter103611582fronter
frontes104214162frontes
frontman1344302frontman
fronton1037202fronton
fronts94415792front_s
rental63922022_rental
agonal7410053agon_al
aortal65217513_aortal
argental947933argental
arousal748633arousal
artal55525473ar__tal
atonal6514023aton_al
axonal1347653axon_al
azonal1568273azon_al
baronial1049483baronial
borstal939043borstal
brantail1046893brantail
bromal10313653bro_mal
brutal859383br_utal
cantal84122033_cantal
cental84420963_cental
clonal8310913clon_al
coital84117053_coital
confrontal1553783confrontal
corneal94414503corneal
cornual94210173cornual
coronal94115763coron_al
costal85419513_costal
cranial92114683cranial
crestal9312133crestal
crustal939023crustal
cryptal1445683cryptal
crystal1237433crystal
dental74319173_dental
dotal64919623_do_tal
fantail10310233f_antail
fatal84819373f__atal
faunal94711593faun_al
festal94213563f_estal
fetal85623373f__etal
final83922033f_in_al
finial92814183f_inial
floatel10308013floatel
floral94313813flo_ral
flota85315643flo_ta_
flotas94013003flo_tas
foal76630923f_o__al
focal104917673f_o_cal
font77143753f_ont__
fontanel1145553f_ontanel
fonts86124753f_ont_s
forestal11410283forestal
formal113215203f_ormal
fornical1347793fornical
foveal1237703f_oveal
foxtail1745383f_oxtail
fractals1346133fractals
frantic12310363frantic
frena85915273fren_a_
frenula1045623frenula
frogman1335873frogman
frond95316343fron__d
fronded12388863fronded
fronds106412343fron_ds
frons86124043fron__s
frontages13116183frontages
frontality1654183frontality
frontier1147313frontier
fronting12310443fronting
frontlet1147653frontlet
frontmen1344423frontmen
frontons1136503frontons
frontpage15102633frontpage
frontward1642573frontward
frost84727833frost__
frosted113211873frosted
frostily1436693frostily
frosts94214623frost_s
frosty124710633frost_y
froth115919283fro_t_h
froths125411443fro_ths
frothy15578373fro_thy
frottage1245083frottage
frugal1036393fr_ugal
frusta937453frusta_
fungal10388733f_ungal
glottal835103glottal
horntail11105033horntail
ironical1049963ironical
ironman936613ironman
krona93611793kron_a_
mental84521603_mental
mortal84616853_mortal
neonatal844383neonatal
nontax1348413_nontax
notal55221353_no_tal
octal71214723__octal
omental93210413omental
orbital936923orbital
oriental848483oriental
parental10310943parental
peroneal1049173peroneal
phonal11310383phon_al
pontil8315463_pontil
portal84218463_portal
postal84317533_postal
prefrontal1552603prefrontal
prenatal1048373prenatal
pronate9418873pronate
pronota939763pronota_
pronto8313993pront_o
protyl11308213pro_tyl
quantal16367893quantal
quintal16389883quintal
ratal55025113_r_atal
rectal84418133_rectal
renal55929503_ren_al
rentals74017473_rentals
rictal83113183_rictal
rondel73212643_rondel
ronnel63310883_ronnel
rostral7311333_rostral
rota45834343_ro_ta_
rotas54827723_ro_tas
rotl45029683_ro_t_l
royal85014703_ro_yal
scrotal938493scro_tal
sponsal946343sponsal
tonal53724303_ton_al
total55321823_to_tal
trinal6516963trin_al
trochal1288243trochal
trona54118953tron_a_
tronas63816903tron_as
trotyl9236673tro_tyl
uprootal1043453uprootal
urinal6614123urin_al
zonal145116853_zon_al
zoonal1558083zoon_al

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271486.84319586.0
3Display Results1481480.0632349.2
 (SQL Overall)1786911487.32624391.3
 
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.