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

125 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
metrical1231158(None) 
metical11315361met_ical
centrical1348342centrical
detrital946572detrital
ethical1238442_ethical
iatrical1049272iatrical
medical12312512me_dical
meticals12310762met_icals
metric10314672metric__
metrically17411072metrically
metricate1349912metricate
metrics11312362metric_s
mythical1845022mythical
retrial7615552retri_al
sterical10311242sterical
vertical13410432vertical
aerial64625713ae_ri_al
altricial1146213altricial
atrial65418943_atri_al
betrayal1343593betrayal
biometrical1755483biometrical
cercal10314123ce_r_cal
cervical1546853cervical
clerical1248233clerical
cortical12412203cortical
decrial10310323decri_al
deifical1445543deifical
deprival1444603deprival
diametrical1654113diametrical
electrical1446133electrical
empirical1544193empirical
epical10413393_e_pical
erica7316543_e_rica_
ericas8315463_e_ricas
ethicals1345533_ethicals
ethnical1346363_ethnical
ferial94621253fe_ri_al
fetial95716193fet_i_al
generical1246983generical
geometrical1655383geometrical
georgical1344023georgical
gestical1138983gestical
hectical1547933hectical
helical12311153he_lical
heroical13410013heroical
icterical1347203icterical
jerrican1794123jerrican
lexical1637363le_xical
lubrical12116093lubrical
lyrical1236493_lyrical
madrigal121627253madrigal
magical1239783m_agical
marital92314183m_arital
martial92415413marti_al
material10314093materi_al
matinal9312603mat_inal
matrices12312083matrices
matricidal1553863matricidal
matronal1048113matronal
medial93819863me_di_al
medicals1349363me_dicals
memorial1249503memori_al
menial84223033me_ni_al
meniscal1246183meniscal
mescal104113483me__scal
mesial84818083me_si_al
metal75427383met___al
metazoal1944473metazoal
methodical1845133methodical
methylal1644263methylal
meticais1248183met_icais
metrazol1943503metrazol
metricated1547293metricated
metricates1449103metricates
metricism1557513metricism
metricize2247213metricize
metrify1535623metri_fy
metring103215283metri_ng
metrist9317063metri_st
metrists1039843metrists
metritis1049183metritis
mezcal19367853me__zcal
mimical1339233m_imical
mistrial10311373mistri_al
mitral81314323mitr__al
musical1139553m_usical
myrica1336823m_yrica_
myricas1436743m_yricas
mystical1546933mystical
nonmetrical1557253nonmetrical
numerical1345963nume_rical
optical1149863opt_ical
outrival1145313outrival
petrosal1047153petrosal
poetical12311533poet_ical
pretrial10511983pretri_al
reprisal1045903reprisal
retial64724993ret_i_al
retinal75318353ret_inal
retral64419743retr__al
retrials8510823retri_als
retrieval1243283retrieval
rhetorical1544573rhetorical
rubrical1296093rubrical
satirical1146873satirical
satyrical1445033satyrical
septical1259363septical
serial64625853se_ri_al
stoical9310273_stoical
symmetrical2073943symmetrical
tertial7313853terti_al
tetanical1146533tetanical
theatrical1544483theatrical
thetical1349123thet_ical
tical76021493__t_ical
trial54926353__tri_al
tribal8611133__tribal
trinal6516953__trinal
turrical1046203turrical
unethical1444523unethical
vatical1239983vat_ical
verticals1457233verticals
verticil1366913verticil
vesical12159813ve_sical
vortical1348863vortical

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621258.36017483.5
3Display Results1251250.0462717.4
 (SQL Overall)1786911258.57920828.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.