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

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

93 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
nitres6551933(None) 
litres65220391litres
mitres83922071mitres
niters64624201niters
nites55736341nit_es
nitre57519681nitre_
nitros64214121nitros
titres64718931titres
antres65021002antres
bistres94017212bistres
biters83925232biters
bites75641172bit_es
cires74932912ci_res
citers85022972citers
cites74435582cit_es
cities84524852cities
citrus83610912citrus
dites66339152dit_es
ditzes163212422ditzes
entires71517782entires
fibres114312122fibres
fires85740752fi_res
gites65630182git_es
goitres8389562goitres
hires86134342hi_res
inters64328042inters
intros64215772intros
inures63318952inures
ires45639282_i_res
kiters105218582kiters
kites95432542kit_es
kithes135016652kithes
liters65429872liters
litre55421462litre_
livres94311862livres
matres84522232matres
metres85121562metres
mires75640882mi_res
miters84328772miters
mites75141802mit_es
mitre75522422mitre_
mitred94414342mitred
nacres85614452nacres
nares55544152n_ares
nates55238332nat_es
natures7311962natures
niches114419142niches
nides65229132ni_des
nieces84112712nieces
nieves94311292nieves
nifties102612502nifties
nines55937342ni_nes
nite45943582nit_e_
niter55028972nit_er
niteries8318372niteries
nitery94412172nitery
nitons64614902nitons
nitrates82516202nitrates
nitric82512062nitric
nitrid72812232nitrid
nitrides92910702nitrides
nitrids8269632nitrids
nitril62511532nitril
nitriles8269922nitriles
nitrils72810702nitrils
nitrites82313452nitrites
nitro54914352nitr_o
nitroso7326452nitroso
nitrous73512482nitrous
nits45741642nit__s
nixes124519622ni_xes
nixies135313872nixies
noters64020992noters
notes55034582not_es
pities83828082pities
rites54442552rit_es
ritzes154812942ritzes
sires55945372si_res
sites56045432sit_es
tires55437492ti_res
titers64526402titers
tithes94720212tithes
titles63719922titles
titre54619392titre_
tres46542902__tres
uniters73814172uniters
unites65024852unit_es
unities72520142unities
unmitres1036862unmitres
vires84529682vi_res
wires86034912wi_res
wites85536962wit_es
withes124620842withes

Search took 3 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 Filter178691825510.1261418182.5
2DLD Change Limit82551932.76329877.3
3Display Results93930.0332818.2
 (SQL Overall)178691932.92261153.7
 
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.