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

208 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
nitrites8231345(None) 
nitrates82516201nitrates
nitrides92910701nitrides
nitriles8269921nitriles
nitrite72314461nitrite_
attrites8311562attrites
citrates102315072citrates
citrines102513132citrines
diorites9313522diorites
niobites1037312niobites
niteries8318372niteri_es
nitrate72017012nitrate_
nitrated92213152nitrated
nitres65519332nitr__es
nitride82811242nitride_
nitrided10276752nitrided
nitrids8269632nitri_ds
nitrifies12107922nitrifies
nitrile73011372nitrile_
nitrils72810702nitri_ls
nitwits1035052nitwit_s
norites74018802n_orites
picrites121811082picrites
titrates82314642titrates
vitrines112610912vitrines
airtimes1037503airtimes
ankerites1348523ankerites
attrite7311833attrite_
attrited947373attrited
attrits7310613attrit_s
azurites1737283azurites
barites94322333_barites
biotites10310083biotites
cerites94823433_cerites
cities84524853cit_i_es
citrate92216793citrate_
citrated112712243citrated
citrine92514023citrine_
citrins92614363citri_ns
citruses1037483citruses
cowrites133011593cowrites
cuprites1259023cuprites
curites93919863_curites
denitrates1169503denitrates
detritus945473detritus
diaries83321953diari_es
diatribes1245533diatribes
diorite8314913diorite_
dirties83119383dirti_es
disrates91118143disrates
ditties83116983ditti_es
editrices1245323editrices
editrixes1743813editrixes
entries71523163entri_es
eucrites1049473eucrites
ferrites112312823ferrites
filtrates1247723filtrates
finites10315923fi_nites
frites94922483__frites
gnathites1344233gnathites
gothites1246013gothites
ignites81310573_ignites
illites72415013_illites
incites93218483_incites
indites83618983_indites
ingrates9514153ingrates
initiates9411183initiates
inosites8312793inosites
interties9320333interties
intines7921113int_ines
intitles8710003int_itles
intrigues1045363intrigues
introits859713introit_s
intrudes937493intrudes
intuited938763intuited
intuits7310313intuit_s
intwines1138043intwines
invites103915813_invites
iolites73819483_iolites
irides74519123_i_rides
irises64221173_i_rises
iritis63113733_i_ritis
iterates81317813_iterates
kitties113213623kitti_es
laterites9715043laterites
latrines8515003latrines
librates103412933librates
lignites9129603lignites
limites92915453li_mites
literates91415643literates
litotes7311183lit_otes
litres65220393litr__es
matrices12312083matrices
matrixes1738063matrixes
metritis1049183metritis
migrates111112843migrates
miscites12313783miscites
misrates101318233misrates
miswrites1447983miswrites
mitises9315543mit_ises
mitres83922073mitr__es
narrates8312753narrates
natives10310823nat_ives
natriums1046293natriums
natrolites1047413natrolites
nephrites1446503nephrites
neurines8311193neurines
neuritis848493neuritis
niceties10310863niceties
nictates1039583nictates
nidates8311883ni_dates
nifties102612503nifti_es
nighties121011383nighties
nigrifies1346363nigrifies
nigritudes1252653nigritudes
nineties8312913nineties
ninnies73713613ninni_es
niobates1037273niobates
niobite937943niobite_
nitchies1339073nitchies
niterie7313743niteri_e_
nites55736343n___ites
nitpicks1643183nitpicks
nitrator849553nitrator
nitrators949203nitrators
nitre57519683nitr__e_
nitric82512063nitri__c
nitrid72812233nitri__d
nitrified1346723nitrified
nitrifier1245963nitrifier
nitrifiers1343923nitrifiers
nitrify1335793nitri_fy
nitril62511533nitri__l
nitrogen945823nitrogen
nitrogens1045353nitrogens
nitros64214123nitr__os
nitrous73512483nitr_ous
nittier73512243nitti_er
nittiest82712603nitti_est
nitwit938593nitwit__
nixies135313873ni_xi_es
norite63221133n_orite_
notaries8314933notari_es
notarizes1848713notarizes
notates72817483not_ates
notices9312283not_ices
nutates73214973nut_ates
nutrias739813nutri_as
nutritives1344153nutritives
outrates82421363outrates
outrides92414993outrides
outwrites1238233outwrites
patriates11311363patriates
petites93820203pet_ites
picrates122013203picrates
picrite111911313picrite_
pinites9319533pi_nites
pirates93020323pi_rates
pities83828083pit_i_es
pyrites12812203_pyrites
ratites74920683rat_ites
retries74129073retri_es
rewrites11311053rewrites
rites54442553___rites
siderites10410423siderites
sienites8311913sienites
situates8310363situates
sorites73825243_sorites
sprites94220333_sprites
stipites1039653stipites
striates83417083_striates
strides84520393_strides
strifes104716583_strifes
strikes114719093_strikes
stripes95320573_stripes
strives104119373_strives
thorites11312393thorites
tillites8312823tillites
titanites997413titanites
titbits935793titbit_s
titrate72215573titrate_
titrated92611683titrated
titres64718933titr__es
titties73617363titti_es
tribes85119023__tribes
trices84826333__trices
tries55742813__tri_es
trikes105419493__trikes
trines64132563__trines
tripes85324873__tripes
trite54730033__trite_
triter65120593__triter
tritest7315273__tritest
uintaites9136333uintaites
unities72520143unit_i_es
unitizes1739133unit_izes
verites103822253_verites
vibrates132210593vibrates
vitiates112311413vitiates
vitrics12198553vitri_cs
vitrifies1547223vitrifies
vitrine102511363vitrine_
vitriols1145053vitriols
witherites1645973witherites
withies133913543withi_es
writes94420333__writes
yperites13310153yperites
zincites1946633zincites

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.1731032896.0
2DLD Change Limit1461622088.65616885.6
3Display Results2082080.0762736.8
 (SQL Overall)1786912088.90520066.4
 
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.