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

62 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
nonionic104923(None) 
nontonic10410151nontonic
amnionic1245602amnionic
anionic9312872_anionic
nontoxic1746232nontoxic
amniotic1246403amniotic
avionic1237693_avionic
bionic103614573__bionic
boronic11311163bo_ronic
bosonic1139213bo_sonic
canonic11312933can_onic
cationic12310013cationic
chorionic1646493chorionic
colonic115015713co_lonic
coniosis1048133coniosis
eosinic947713eosi_nic
gnomonic1345903gno_monic
gonidic1166103goni_dic
gonion73612833gonion__
hormonic1568153hormonic
ionic74622663___ionic
monistic12311303monistic
monodic1269783mon_odic
monotonic1348583monotonic
moronic11311863mo_ronic
nektonic1445723nektonic
neuronic1049013neuronic
niobic1037243__niobic
nomistic1279593nomistic
nonatomic1346463nonatomic
nonbasic1246243nonbasic
nonerotic1169113nonerotic
nonethnic1444643nonethnic
nonexotic1875493nonexotic
noniron738373noniron__
nonlyric1344863nonlyric
nonmoney1346273nonmoney
nonmusic1244993nonmusic
nonohmic1545553nonohmic
nonpoetic1347223nonpoetic
nonpoint10411863nonpoint
nonpolice1345663nonpolice
nonrhotic1445783nonrhotic
nonsolid957413nonsolid
nontonal849743nontonal
noritic91213543nori_tic
notion64516583notion__
notional849403notional
notions74014483notion_s
obconic1346353_obconic
onion54320973_onion__
onions64016433_onion_s
oniony9369703_onion_y
opsonic1137253_opsonic
ovonic11288183_o_vonic
ozonic17308943_o_zonic
pionic103515953__pionic
ronion63315643ronion__
ronions73313343ronion_s
syntonic1347703syntonic
thionic1238893_thionic
unironic1046053_unironic

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.436409841.7
2DLD Change Limit146162627.86018595.7
3Display Results62620.0302066.7
 (SQL Overall)178691628.32621461.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.