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

257 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
nitrates8251620(None) 
citrates102315071citrates
nitrate72017011nitrate_
nitrated92213151nitrated
nitrites82313451nitrites
titrates82314641titrates
citrate92216792citrate_
citrated112712242citrated
denitrates1169502denitrates
disrates91118142disrates
filtrates1247722filtrates
ingrates9514152ingrates
initiates9411182initiates
iterates81317812_iterates
librates103412932librates
literates91415642literates
migrates111112842migrates
misrates101318232misrates
narrates8312752narrates
nictates1039582nictates
nidates8311882ni_dates
niobates1037272niobates
nitrator849552nitrator
nitrators949202nitrators
nitres65519332nitr__es
nitrides92910702nitrides
nitriles8269922nitriles
nitrite72314462nitrite_
notates72817482not_ates
nutates73214972nut_ates
outrates82421362outrates
picrates122013202picrates
pirates93020322pi_rates
situates8310362situates
titrate72215572titrate_
titrated92611682titrated
vibrates132210592vibrates
vitiates112311412vitiates
acierates11310793acierates
actuates10310303actuates
aerates74627483_aerates
agitates9310873agit_ates
airdates939713airdates
aliterates101510743aliterates
amirates101114793amirates
animates101316423ani_mates
antitrades1146523antitrades
arbitrates12117003arbitrates
attrites8311563attrites
berates94126853_berates
birthrates1545003birthrates
borates94823013_borates
butyrates1446063butyrates
carates95630603_carates
castrates11312663castrates
cerates95428233_cerates
ciliates10413443ciliates
cirrate92413483cirrate_
citrals91111663citra_ls
citrines102513133citrines
citruses1037483citruses
crates85736053__crates
curates95323823_curates
denigrates1298103denigrates
denitrate10810533denitrate_
denitrated1298033denitrated
derates84028883_derates
dictates11311373dictates
dilates83220653di_lates
diorites9313523diorites
disrate81418523disrate_
disrated10915573disrated
emigrates1248563emigrates
emirates101214843emirates
estates74520173est_ates
ferrates113013403ferrates
filiates11412653filiates
filtrate1148223filtrate_
filtrated1345963filtrated
fixates1737383fi_xates
grates75429883__grates
gyrates113610263_gyrates
hydrates15229403hydrates
ideates8313723_ideates
imitates10310503imit_ates
indurates10310693indurates
infiltrates1463943infiltrates
inflates11512193inflates
ingates82716893_ingates
ingrate8715113ingrate_
initiate8412693initiate_
initiated10510113initiated
inmates92715763_inmates
instates81615823instates
intakes11310943int_akes
integrates111010773integrates
intimates111013303intimates
intonates9410233intonates
intrados946563intrados
intranet8418443intranet
intranets949263intranets
intrants8312863intrants
intreated10312663intreated
intreats8311543intreat_s
intrudes937493intrudes
intubates1147113intubates
iodates8312893_iodates
irades74517393_i_rades
irate55627983_i_rate_
irater65218343_i_rater
iratest7312483_i_ratest
iterate71119103_iterate_
iterated91213813_iterated
juniorates1743583juniorates
karates115617473_karates
liberates111012933liberates
librate93214233librate_
librated113110313librated
liftgates1343513liftgates
ligates82318373li_gates
liquates1737443liquates
literate81216883literate_
literatus9146813literatus
litigates1048003litigates
litotes7311183lit_otes
litres65220393litr__es
lustrates939453lustrates
maturates11311753maturates
metates92720003met_ates
micturates1456083micturates
migrate101314163migrate_
migrated121110493migrated
mirages102213533mi_rages
misdates111113623misdates
mismates121114553mismates
misrate91319143misrate_
misrated111315383misrated
mistraces13312283mistraces
mitigates1248253mitigates
mitres83922073mitr__es
mutates92215793mut_ates
narrate7313493narrate_
narrated9310323narrated
narrater838723narrater
narraters946693narraters
nates55238333n___ates
negates83215833n_egates
neonates8310063neonates
nictate9310223nictate_
nictated1137793nictated
nictitates1244953nictitates
nidate7313783ni_date_
nidated939863ni_dated
niobate937703niobate_
niobites1037313niobites
nitchies1339073nitchies
niteries8318373niteries
nites55736343ni___tes
nitrating10312673nitrating
nitration9313443nitration
nitrations10312033nitrations
nitre57519683nitr__e_
nitride82811243nitride_
nitrided10276753nitrided
nitrids8269633nitr_ids
nitrifies12107923nitrifies
nitrile73011373nitrile_
nitrils72810703nitr_ils
nitrogen945823nitrogen
nitrogens1045353nitrogens
nitros64214123nitr__os
nitrous73512483nitr_ous
nitwits1035053nitwit_s
nizamates2043263nizamates
nonrated9310843nonrated
norites74018803n_orites
notaries8314933notaries
notate63217863not_ate_
notated82713663not_ated
novitiates1343733novitiates
numerates11199553numerates
nutate63017373nut_ate_
nutated83113423nut_ated
nutcases1085793nutcases
obturates1156993obturates
operates10515403operates
orates64328613__orates
outdates93114743outdates
outraces102217863outraces
outrages92215923outrages
outrate72323183outrate_
outrated92219313outrated
outraves112313833outraves
patriates11311363patriates
penetrates1248713penetrates
petrales10312953petrales
phorates13413043phorates
picrate112014143picrate_
picrated132110113picrated
picrites121811083picrites
pirate82322883pi_rate_
pirated102515613pi_rated
prates84633163__prates
priorates11410753priorates
prorates10418063prorates
rates55352013___rates
recrates102420353recrates
regrates92618373regrates
reiterates10411983reiterates
retraces101417263retraces
rotates72819773rot_ates
sanitates9611733sanit_ates
satiates8314633satiates
saturates9811593saturates
serrates82617003serrates
sinuates8310953sinuates
situate7410773situate_
situated938023situated
states64337083_st_ates
strafes104515993_strafes
strakes114218073_strakes
stratas73013573_stratas
straths102711713_straths
stratus73011723_stratus
striates83417083_striates
tartrates979553tartrates
tates55444983__t_ates
tirades8311723ti_rades
titanates976083titanates
titivates1246433titivates
titrants838483titrants
titrator858543titrator
titrators948353titrators
titres64718933titr__es
traces85329933__traces
trades75724493__trades
trapes85024463__trapes
traves94222743__traves
triturates1046743triturates
uncrates10314553uncrates
unitages938273unit_ages
unstates81314993unst_ates
uprates93814863_uprates
urates65027763__urates
vibrate122811513vibrate_
vibrated14228383vibrated
vibratos13217473vibratos
vicarates1487613vicarates
violates11311183violates
virgates1237903virgates
vitiate103412953vitiate_
vitiated12289223vitiated
vitrains1138283vitrains
vitrines112610913vitrines
vittate10409723vittate_
vizirates2144653vizirates
zincates1937733zincates

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.1561145455.1
2DLD Change Limit1461622578.14317949.4
3Display Results2572570.1102336.4
 (SQL Overall)1786912578.40921250.0
 
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.