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

79 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
negroni84683(None) 
negronis947261negronis
negroid9108892negroid
neroli61111152ne_roli
neuron6310372neuron_
neurone739432neurone
neuronic1049012neuronic
neurons7410442neurons
begone9512133beg_one
begonia1047213beg_onia
begroan1036103begroan
begroans1145503begroans
engrain838353engrain
engross837123engross
groin65521083__groin
heroin94420593he_roin
heron85025503he_ron_
herons94820543he_rons
legion75712983legion_
legions84611783legions
legong836963leg_ong
legroom1076093legroom
ligroin848043ligroin
megaron10248303megaron_
natron64116023natron_
natrons73215663natrons
nearing83020333nearing
necrose939723necrose
necrosis1048883necrosis
necrotic12310043necrotic
negaton8299143negaton_
negatons9299273negatons
negatron9335993negatron_
negatrons10275843negatrons
negroids10116323negroids
negrophil1554953negrophil
nekton1036583nekton_
nektonic1445723nektonic
nektons1136393nektons
nelson638423nelson_
nelsons738003nelsons
neocon836713neocon_
neocons936913neocons
neon47026423ne__on_
neons55818683ne__ons
nephron1246653nephron_
nephrons1346853nephrons
nerol51017813ne_ro_l
nerolis71012773ne_rolis
nerols6914883ne_rols
neurine7311683neurine
neuroid81110303neuroid
neuroma946523neuroma
neuronal846893neuronal
neurones839673neurones
neurosis848843neurosis
neurotic1039693neurotic
neutron737763neutron_
neutronic1145943neutronic
neutrons838293neutrons
newton936983newton_
newtons1036813newtons
nigrosin945233nigrosin
padroni10278613padroni
peperoni1246273peperoni
perron83216623perron_
perrons93115483perrons
refront10313263refront
region74614903region_
regions83613473regions
regrant8317323regrant
regrind938983regrind
regroom1077303regroom
reground1045073reground
regroup1095173regroup
regrow10309883regro_w
regrown11237363regrown
regrows11269153regrows
segni63712483seg__ni

Search took 7 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.406440125.6
2DLD Change Limit134027795.84322938.0
3Display Results79790.0332393.9
 (SQL Overall)178691796.28228444.9
 
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.