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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

202 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
nitrite7231446(None) 
nitrate72017011nitrate
nitride82811241nitride
nitrile73011371nitrile
nitrites82313451nitrites
attrite7311832attrite
citrate92216802citrate
citrine92514022citrine
diorite8314912diorite
niobite937952niobite
niterie7313742niteri_e
nitrated92213152nitrated
nitrates82516222nitrates
nitre57519682nitr__e
nitric82512062nitri_c
nitrid72812232nitri_d
nitrided10276752nitrided
nitrides92910702nitrides
nitrids8269632nitrids
nitrify1335792nitrify
nitril62511532nitri_l
nitriles8269922nitriles
nitrils72810702nitrils
nitwit938592nitwit_
nitwits1035052nitwits
norite63221132n_orite
picrite111911312picrite
titrate72215572titrate
trite54730032__trite
vitrine102511362vitrine
airtime948063airtime
ankerite1248923ankerite
astride8311973astride
attrit6315753attrit_
attrited947373attrited
attrites8311573attrites
attrits7310623attrits
azurite1638003azurite
barite84224813_barite
biotite9311033biotite
cerite84724873_cerite
cirrate92413493cirrate
citrated112712253citrated
citrates102315093citrates
citric102812313citri_c
citrin82615413citri_n
citrines102513133citrines
citrins92614363citrins
contrite10318543contrite
cowrite123612683cowrite
cuprite1159683cuprite
curite85222943_curite
denitrate10810533denitrate
diatribe1145673diatribe
diorites9313523diorites
disrate81418523disrate
distraite10611483distraite
eucrite939903eucrite
ferrite103312753ferrite
filtrate1148223filtrate
finite9316823fi_nite
gnathite1244483gnathite
gothite1146403gothite
ignite71410583_ignite
illite63414923_illite
incite83618733_incite
indite73520323_indite
ingrate8715123ingrate
initiate8412693initiate
inosite7314063inosite
intertie8317613intertie
intime81014273int_ime
intine61021983int_ine
intitle7610583int_itle
intricate11411193intricate
intrigue945233intrigue
introit7414533introit_
introits859713introits
intrude837403intrude
intuit6314083intuit_
intuited938763intuited
intuits7310313intuits
intwine1038513intwine
invite93715033_invite
iolite63221983_iolite
irate55627983_i_rate
iterate71119113_iterate
laterite8716353laterite
latrine7715133latrine
librate93214233librate
lignite81310303lignite
literate81216893literate
litre55421463litr__e
migrate101314173migrate
miscite11314383miscite
misrate91319143misrate
miswrite1348923miswrite
mitre75522423mitr__e
mitring103514143mitring
narine63422553n_arine
narrate7313493narrate
native9613013nat_ive
natrium948993natrium
natrolite948023natrolite
nephrite1346713nephrite
netlike11308913netlike
neurine7311683neurine
niblike1336703niblike
nicoise937933nicoise
nictate9310223nictate
nidate7313783ni_date
nightie1179653nightie
nigrify1444133nigrify
nigritude1152663nigritude
niobate937703niobate
niobites1037313niobites
nitchie1247233nitchie
nite45943593n___ite
niteries8318383niteries
nitid61817833nit_i_d
nitpick1543783nitpick
nitrator849553nitrator
nitres65519333nitr_es
nitrified1346733nitrified
nitrifier1245963nitrifier
nitrifies12107923nitrifies
nitro54914353nitr__o
nitrogen945823nitrogen
nitros64214123nitr_os
nitroso7326453nitroso
nitrous73512483nitrous
nittier73512243nittier
nitty85418313nit__ty
nixie125114943ni_xi_e
norites74018803n_orites
notarize1749293notarize
notate63217863not_ate
notice8313443not_ice
nutate63017373nut_ate
nutlike113110113nutlike
nutria639913nutri_a
nutrias739813nutrias
nutritive1245333nutritive
outrate72323183outrate
outride82615683outride
outwrite1139453outwrite
partite9317133partite
patriate10311933patriate
petite84320653pet_ite
picrate112014143picrate
picrites121811083picrites
pinite8321243pi_nite
pirate82322883pi_rate
pyrite11913313_pyrite
ratite65022423rat_ite
rewrite10311143rewrite
rite45849463___rite
siderite9411363siderite
sienite7312713sienite
situate7410783situate
sprite84421773_sprite
striae65422273_striae
striate74218953_striate
stride75420963_stride
strife95318363_strife
strike105619733_strike
stripe85822443_stripe
strive95020963_strive
thorite10313443thorite
tillite7313563tillite
titanite898433titanite
titbit839823titbit_
titbits935803titbits
titmice1144663titmice
titrated92611683titrated
titrates82314663titrates
titre54619393titr__e
tittie63213153titti_e
tribe74420273__tribe
trice75127493__trice
trike95320163__trike
trine54734603__trine
tripe75425383__tripe
triste63818643__triste
triter65120593__triter
uintaite8127353uintaite
unitive10310563unit_ive
unitize16310033unit_ize
verite94323443_verite
vibrate122811523vibrate
virile9313433vi_rile
vitiate103412953vitiate
vitric112510113vitri_c
vitrics12198553vitrics
vitrify1645003vitrify
vitrines112610913vitrines
vitriol1045693vitriol
vittate10409733vittate
witherite1546693witherite
write85522833__write
yperite1249893yperite
zincite1837233zincite

Search took 10 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 Limit1340272028.61015566.4
3Display Results2022020.0762657.9
 (SQL Overall)1786912029.09219653.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.