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

290 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
nitrate7201701(None) 
citrate92216801citrate
nitrated92213151nitrated
nitrates82516221nitrates
nitrite72314461nitrite
titrate72215571titrate
cirrate92413492cirrate
citrated112712252citrated
citrates102315092citrates
denitrate10810532denitrate
disrate81418522disrate
filtrate1148222filtrate
ingrate8715122ingrate
initiate8412692initiate
irate55627982_i_rate
iterate71119112_iterate
librate93214232librate
literate81216892literate
migrate101314172migrate
misrate91319142misrate
narrate7313492narrate
nictate9310222nictate
nidate7313782ni_date
niobate937702niobate
nitrator849552nitrator
nitre57519682nitr__e
nitride82811242nitride
nitrile73011372nitrile
nitrites82313452nitrites
notate63217862not_ate
nutate63017372nut_ate
outrate72323182outrate
picrate112014142picrate
pirate82322882pi_rate
situate7410782situate
titrated92611682titrated
titrates82314662titrates
vibrate122811522vibrate
vitiate103412952vitiate
vittate10409732vittate
acerate92818913acerate
acierate10311813acierate
actuate9311443actuate
aerate64830553_aerate
agitate8312063agit_ate
airdate8311323airdate
aliterate91611333aliterate
amirate91115953amirate
animate91617213ani_mate
antirape10410113antirape
antitrade1046523antitrade
arbitrate11137373arbitrate
attrite7311833attrite
aurate64426473_aurate
berate84729023_berate
biforate1346903biforate
binate8419773bi_nate
birthrate1445303birthrate
bistate9313823bistate
borate85026153_borate
butyrate1346203butyrate
carate84734003_carate
castrate10313863castrate
cerate84829463_cerate
ciliate9514603ciliate
citral81113893citra_l
citrals91111673citrals
citrine92514023citrine
crate76537403__crate
cultrate10310873cultrate
curate85226243_curate
curtate9312643curtate
denigrate1168693denigrate
denitrated1298033denitrated
denitrates1169513denitrates
derate74531233_derate
dictate10311663dictate
dilate73220693di_late
diorite8314913diorite
disrated10915573disrated
disrates91118153disrates
distraite10611483distraite
emigrate1149603emigrate
emirate91015833emirate
estate64719763est_ate
ferrate103014043ferrate
figurate1237193figurate
filiate10414233filiate
filtrated1345963filtrated
filtrates1247733filtrates
fissate103010033fissate
fixate1638733fi_xate
grate64932883__grate
guttate8328903guttate
gyrate104912523_gyrate
hydrate14239813hydrate
ideate7313683_ideate
imitate9310873imit_ate
increate10312203increate
indurate9311873indurate
infiltrate1354113infiltrate
inflate10312313inflate
ingate73018243_ingate
ingrates9514173ingrates
initiated10510113initiated
initiates9411183initiates
inmate82917363_inmate
innate63917313_innate
instate71616483instate
intake10510863int_ake
integrate10911153integrate
interage9314483interage
intimate101013833intimate
intonate8310923intonate
intranet8418443intranet
intrant7318753intrant
intrants8312863intrants
intreat7416303intreat_
intreated10312663intreated
intreats8311543intreats
intricate11411193intricate
intrude837403intrude
intubate1047533intubate
iodate7313503_iodate
irade65618153_i_rade
irater65218353_i_rater
iterated91213823_iterated
iterates81317823_iterates
juniorate1644013juniorate
karate105320923_karate
liberate101113383liberate
librae84310173libra_e
librated113110313librated
librates103412953librates
liftgate1243413liftgate
ligate72519253li_gate
limbate1139213limbate
lineate7815153lineate
liquate1638423liquate
literates91415653literates
literati81210803literati
litigate948303litigate
litre55421463litr__e
lustrate8310443lustrate
lyrate94112103_lyrate
maturate10312613maturate
metate82720533met_ate
micturate1366643micturate
migrated121110513migrated
migrates111112853migrates
mirage92313653mi_rage
misate81222693mi_sate
misdate101413963misdate
mismate111415353mismate
misrated111315383misrated
misrates101318243misrates
mistrace12312643mistrace
mitigate1148693mitigate
mitral81314323mitra_l
mitre75522423mitr__e
mutate83017483mut_ate
narrated9310323narrated
narrater838723narrater
narrates8312763narrates
negate72915573n_egate
neonate7311333neonate
nervate1039523nervate
nictated1137793nictated
nictates1039593nictates
nictitate1145403nictitate
nidated939863ni_dated
nidates8311893ni_dates
niobates1037283niobates
niobite937953niobite
nitchie1247233nitchie
nite45943583ni___te
niterie7313743niterie
nitrating10312673nitrating
nitration9313443nitration
nitrators949213nitrators
nitres65519333nitr_es
nitric82512063nitr_ic
nitrid72812233nitr_id
nitrided10276753nitrided
nitrides92910703nitrides
nitrids8269633nitrids
nitrify1335793nitrify
nitril62511533nitr_il
nitriles8269923nitriles
nitrils72810703nitrils
nitro54914353nitr__o
nitrogen945823nitrogen
nitros64214123nitr_os
nitroso7326453nitroso
nitrous73512483nitrous
nitty85418313nit__ty
nitwit938593nitwit_
nitwits1035053nitwits
nizamate1943533nizamate
nonrated9310843nonrated
norite63221133n_orite
notated82713663not_ated
notates72817483not_ates
novitiate1244223novitiate
numerate101610393numerate
nutated83113423nut_ated
nutates73214973nut_ates
nutcase975763nutcase
obturate1077773obturate
operate9615733operate
orate55133303__orate
outate62923403out_ate
outdate83016423outdate
outrace92418553outrace
outrage82616893outrage
outrated92219313outrated
outrates82421373outrates
outrave102614413outrave
overate10620963overate
patriate10311933patriate
penetrate1149233penetrate
petrale9312623petrale
phorate12413363phorate
picrated132110113picrated
picrates122013213picrates
picrite111911313picrite
pileate93815923pileate
pinnate93613743pinnate
pirated102515613pi_rated
pirates93020333pi_rates
prate75135983__prate
priorate10411733priorate
prorate9418733prorate
rate45458763___rate
recrate92621663recrate
regrate82618663regrate
reiterate9412933reiterate
retrace91417343retrace
rostrate8313843rostrate
rotate63320343rot_ate
sanitate8612043sanit_ate
satiate7315403satiate
saturate8312813saturate
serrate73017543serrate
sigmate10710143sigmate
sinuate7412163sinuate
situated938033situated
situates8310373situates
state56237333_st_ate
strafe95215983_strafe
strake104017393_strake
strata63616283_strata
strath93216373_strath
strati63518903_strati
striate74218953_striate
tartrate899683tartrate
tate44748603__t_ate
tirade7311693ti_rade
titanate897173titanate
titivate1146803titivate
titrable1038963titrable
titrant7315193titrant
titrants838483titrants
titrator858543titrator
titre54619393titr__e
trace75829613__trace
trade65026043__trade
trave85223033__trave
trite54730033__trite
triturate947483triturate
uncrate9415953uncrate
underate9918603underate
unitage838993unit_age
unstate71916213unst_ate
uprate83916543_uprate
urate55432163__urate
vibrated14228393vibrated
vibrates132210613vibrates
vibrato12247383vibrato
vicarate1378603vicarate
violate10311553violate
virgate1138733virgate
vitae84217633vit_a_e
vitiated12289223vitiated
vitiates112311433vitiates
vitrain1038943vitrain
vitrine102511363vitrine
vittae93911003vitta_e
vizirate2045353vizirate
zincate1838533zincate

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.1561145455.1
2DLD Change Limit1340272908.56315651.9
3Display Results2902900.453640.2
 (SQL Overall)1786912909.17219482.2
 
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.