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

81 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
nonmetal104965(None) 
nonmental11410861nonmental
nonmetals1147341nonmetals
gunmetal1143212gunmetal
nonfatal1146052nonfatal
nonlegal946082nonlegal
nonlethal1245142nonlethal
nonmeat9312772nonme_at
nonmetro1045372nonmetro
nonmodal1146592nonmodal
nonmoral1049232nonmoral
nonmortal1146492nonmortal
nonmutual1143732nonmutual
nonvital1147022nonvital
noumenal1046172noumenal
bimetal1138433_bimetal
bonemeal1245173bonemeal
conceal113313023conce_al
congeal104011683conge_al
cornmeal1245853cornme_al
foetal9311883fo__etal
fontal9313143fon__tal
gametal1037603_gametal
gomeral1038843go_meral
gunmetals1242903gunmetals
metal75427383___metal
monumental1455213monumental
nametag1044443n_ametag
neonatal844383neon_atal
nominal92712373no_minal
noncentral1248013noncentral
noncereal1157753noncereal
noncoital1148593noncoital
nonequal1746073nonequal
nonet54540843non_et__
nonets64118703non_et_s
nonfeudal1343703nonfeudal
nonfinal1147703nonfinal
nonfocal1346443nonfocal
nongenital1156683nongenital
nonideal947303nonideal
nonlevel1144373nonlevel
nonlocal1047513nonlocal
nonloyal1145123nonloyal
nonman8412363nonm__an
nonmanual1144903nonmanual
nonmarital1246143nonmarital
nonmedical1566483nonmedical
nonmen8412833nonme__n
nonmetallic1553333nonmetallic
nonmetric1348073nonmetric
nonmetrical1557263nonmetrical
nonmortals1254323nonmortals
nonmotile1146233nonmotile
nonmutant1145873nonmutant
nonnasal845443nonnasal
nonnaval1144613nonnaval
nonneural945103nonneural
nonoral7313603non_oral
nonpapal1244543nonpapal
nonpeak1345473nonpe_ak
nonpostal1145913nonpostal
nonrival1146623nonrival
nonroyal1145753nonroyal
nonrural847363nonrural
nonserial9611983nonserial
nonsexual1645393nonsexual
nontax1348413non__tax
nontidal948673nontidal
nontonal849743nontonal
nonverbal1445253nonverbal
nonviral1146743nonviral
nonvocal1346123nonvocal
normal83213533norm__al
notal55221353no___tal
noumena945633noumena_
numeral939083n_umeral
omental93210423_o_mental
societal1045723societal
somital939403so_mital
sonantal886263sonantal

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.436409841.7
2DLD Change Limit146162817.50019488.3
3Display Results81810.0461760.9
 (SQL Overall)178691817.98222386.7
 
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.