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 “nonmetrical” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

80 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
nonmetrical155726(None) 
nonethical1545992non_ethical
nonmedical1566482nonme_dical
nonmetric1348072nonmetric__
biometrical1755483biometrical
diametrical1654123diametrical
geometrical1655393geometrical
metrical12311593___metrical
nonclerical1555323nonclerical
nonelectrical1763483nonelectrical
nonempirical1863003nonempirical
nongeometrical1972253nongeometrical
nonlexical1945213nonle_xical
nonmarital1246143nonm_arital
nonmaterial1356393nonmateri_al
nonmetal1049643nonmet___al
nonmusical1455173nonm_usical
nonmystical1854343nonmystical
nonnumerical1662853nonnume_rical
nonsensical1364743nonsensical
nonserial9611963nonse_ri_al
nonsymmetrical2391953nonsymmetrical
nontheatrical1873143nontheatrical
nontribal1145873non__tribal
numerical1345973n_ume_rical
symmetrical2073953symmetrical
asymmetrical2182884asymmetrical
centrical1348354cen__trical
chimerical1954534chime_rical
chronometrical2372274chronometrical
commercial1855284comme_rcial
dogmatical1674724dogmat_ical
endometrial1454064endometri_al
generical1247004gen_e_rical
genetical1247584gen_et_ical
hermetical1746384hermet_ical
metical11315364___met_ical
noncentral1248004noncentr__al
noncereal1157744nonce_r_eal
nonchemical2075614nonchemical
nonclinical1554494nonclinical
noncritical1556114noncritical
noncyclical1753334noncyclical
nongenital1156684nonge_nital
nonhistorical1863824nonhistorical
nonhysterical2162654nonhysterical
nonidentical1554334nonidentical
nonlethal1245134nonlet__hal
nonlogical1347064non_logical
nonmechanical2273024nonmechanical
nonmental11410854nonme__ntal
nonmercurial1682754nonmercuri_al
nonmetals1147324nonmet___als
nonmetaphorical2481254nonmetaphorical
nonmetro1045374nonmetr___o
nonmoral1049234nonm_or__al
nonmortal1146494nonm_or_tal
nonmusicals1553294nonm_usicals
nonmutual1143734nonmut__ual
nonneural945094nonneur__al
nonoptimal1453834nonopt_imal
nonphysical2153744nonphysical
nonrival1146624non___rival
nonserials1068034nonse_ri_als
nonspherical1963604nonspherical
nonsteroidal1362474nonsteroidal
nonsurgical1463144nonsurgical
nontechnical1963524nontechnical
nonterminal1355314nonterminal
nontidal948674non__t_idal
nontrivial1354874non__trivial
nontropical1555274nontropical
nontypical1754544non_typical
nonverbal1445244nonve_r_bal
novercal1345684no_ve_r_cal
obstetrical1552354obstetrical
poetical12311534po__et_ical
unethical1444524_un_ethical
unsymmetrical2262054unsymmetrical
zoometric2246634zoometric__

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 Filter1786911488190.420425454.8
2DLD Change Limit148819808.09318388.6
3Display Results80800.0501600.0
 (SQL Overall)178691808.56320867.8
 
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.