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

236 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
nitrated9221315(None) 
citrated112712251citrated
nitrate72017011nitrate_
nitrates82516221nitrates
titrated92611681titrated
citrate92216802citrate_
citrates102315092citrates
denitrated1298032denitrated
disrated10915572disrated
filtrated1345962filtrated
initiated10510112initiated
intreated10312662intreated
iterated91213822_iterated
librated113110312librated
migrated121110512migrated
misrated111315382misrated
narrated9310322narrated
nictated1137792nictated
nidated939862ni_dated
nitrator849552nitrator
nitrided10276752nitrided
nitrite72314462nitrite_
nitrites82313452nitrites
nonrated9310842nonrated
notated82713662not_ated
nutated83113422nut_ated
outrated92219312outrated
picrated132110112picrated
pirated102515612pi_rated
situated938032situated
titrate72215572titrate_
titrates82314662titrates
vibrated14228392vibrated
vitiated12289222vitiated
acerated113113983acerated
acierated1238283acierated
actuated1138743actuated
aerated85322373_aerated
agitated1038413agit_ated
airted74214503ai_r_ted
animated111612373ani_mated
arbitrated13125523arbitrated
attracted1246073attracted
attrited947373attrited
aurated83817793_aurated
berated104422133_berated
betrayed1436303betrayed
biparted1335133biparted
bitted94418483bit__ted
borated104116363_borated
castrated1239513castrated
cerated103922473_cerated
ciliated11510953ciliated
cirrate92413493cirrate_
crated94827773__crated
cultrated1248223cultrated
curated104717583_curated
denigrated1366973denigrated
denitrate10810533denitrate_
denitrates1169513denitrates
derated93623503_derated
detracted1357793detracted
dictated1239203dictated
dilated93115823di_lated
disrate81418523disrate_
disrates91118153disrates
distracted1448873distracted
emigrated1347073emigrated
entreated10310973entreated
estated83715573est_ated
estrayed1236393estrayed
estreated1039553estreated
extracted1946723extracted
filiated12610083filiated
filtrate1148223filtrate_
filtrates1247733filtrates
fitted104716663fit__ted
fixated1835533fi_xated
girted83912873gi_r_ted
gitted84015053git__ted
grated84523923__grated
guttated10266873guttated
gyrated12428413_gyrated
hydrated16216953hydrated
ideated9310973_ideated
imitated1138263imit_ated
indurated1139013indurated
infiltrated1553433infiltrated
inflated12410863inflated
infracted1546363infracted
infrared1236193infrared
ingrafted1444423ingrafted
ingrate8715123ingrate_
ingrates9514173ingrates
initialed1065353initialed
initiate8412693initiate_
initiates9411183initiates
instated91613343instated
integrated1289293integrated
interacted13411213interacted
intimated121010893intimated
intonated1048303intonated
intorted9310123intorted
intranet8418443intranet
intruded1035993intruded
intrusted1076903intrusted
intubated1246453intubated
intuited938763intuited
iodated9310023_iodated
irate55627983_i_rate_
irater65218353_i_rater
iterate71119113_iterate_
iterates81317823_iterates
kitted115114833kit__ted
knitted12337423knit__ted
liberated1299473liberated
librate93214233librate_
librates103412953librates
ligated92414143li_gated
lineated9711063lineated
liquated1835493liquated
literate81216893literate_
literates91415653literates
litigated1146563litigated
lustrated1037963lustrated
lyrated11388473_lyrated
maturated1249163maturated
micturated1584993micturated
migrate101314173migrate_
migrates111112853migrates
misdated121211123misdated
mismated131111333mismated
misrate91319143misrate_
misrates101318243misrates
mistraced1439453mistraced
mistreated1348423mistreated
mitigated1347083mitigated
mitred94414343mitr__ed
mutated102712253mut_ated
narrate7313493narrate_
narrater838723narrater
narrates8312763narrates
negated93413233n_egated
netted74118713net__ted
nictate9310223nictate_
nictates1039593nictates
nictitated1344403nictitated
nidate7313783ni_date_
nidates8311893ni_dates
niobate937703niobate_
niobates1037283niobates
nitrating10312673nitrating
nitration9313443nitration
nitrators949213nitrators
nitre57519683nitr__e_
nitres65519333nitr__es
nitrid72812233nitr__id
nitride82811243nitride_
nitrides92910703nitrides
nitrified1346723nitrified
nitrile73011373nitrile_
nitriles8269923nitriles
nitrogen945823nitrogen
notate63217863not_ate_
notates72817483not_ates
numerated12177873numerated
nutate63017373nut_ate_
nutates73214973nut_ates
nutted74316973nut__ted
obturated1245953obturated
operated11512223operated
orated74221503__orated
outdated1012513193outdated
outraced112414203outraced
outraged102313103outraged
outrate72323183outrate_
outrates82421373outrates
outraved122511923outraved
patriated1238533patriated
penetrated1347303penetrated
picrate112014143picrate_
picrates122013213picrates
pileated112711133pileated
pinnated11338553pinnated
pirate82322883pi_rate_
pirates93020333pi_rates
pitted94319593pit__ted
prated94924923__prated
prorated11513713prorated
rated65441383___rated
recrated112918603recrated
regrated102816333regrated
reiterated11410153reiterated
retraced111413023retraced
retracted12410953retracted
retreated10312623retreated
rotated82715293rot_ated
sanitated1068993sanit_ated
satiated9311603satiated
saturated1038993saturated
serrated92513433serrated
sinuated938413sinuated
situate7410783situate_
situates8310373situates
started84217323_started
stated75427833_st_ated
strafed114413333_strafed
straked125415343_straked
strawed114813613_strawed
strayed114513283_strayed
striated93414153_striated
tarted74923373__tarted
tartrated1096643tartrated
teated74924023__teated
tiaraed837053tiara_ed
titivated1345443titivated
titrator858543titrator
traced94821583__traced
traded85717683__traded
treated83618703__treated
tritiated1047523tritiated
triturated1145073triturated
ultrared936663ultrared
uncrated11416313uncrated
unrated82621553_unrated
unstated91615813unst_ated
untraced112413243untraced
untreated10312903untreated
uprated103213323_uprated
vibrate122811523vibrate_
vibrates132210613vibrates
violated1237883violated
vitiate103412953vitiate_
vitiates112311433vitiates
vittate10409733vittate_
witted104216813wit__ted

Search took 8 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.403443402.0
2DLD Change Limit1461622366.95321021.4
3Display Results2362360.0932537.6
 (SQL Overall)1786912367.44923988.6
 
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.